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...
patrick_hh : excel does not allow negative time.
You need to use conditional formatting to reflect cells in 'Red'/ 'Green' color to show ahead to behind schedule.
Or you can have additional column to reflect status, like below image: