Forum Discussion
Calculating with times : time ahead or behind schedule
I'm trying to calculate how much time someone is ahead or behind schedule, but am getting ###### when the outcome is a negative value. Ahead of schedule should give me an output of hh:mm (positi...
Excel doesn't show negative time in time format - time is always positive.
There are workarounds to show difference of times in time format if it is negative. We may display it as text using formula as here https://excelribbon.tips.net/T006239_Displaying_Negative_Times.html or like.
Another way is to display it as number with digital part. For example, if show in minutes, time difference could be
=(B1-A1)*24*60applying to the result number format.