Forum Discussion
Calculating difference between dates and times
Trying to calculate the difference between planned finish date/time and actual finish date/time. When the difference is positive the answer is returned in the correct format (line 3) but when ne...
With the default setting, Excel cannot display negative times.
You might specify the 1904 date system in Excel Options, but that would shift all dates by 4 years.
As an alternative, convert negative differences to positive ones, and use conditional formatting to apply a custom number format to the cells where the actual difference is negative.
See the attached workbook.