ExcelBanter - How do I calculate and show negative time in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I calculate and show negative time in Excel? (https://www.excelbanter.com/excel-worksheet-functions/44145-how-do-i-calculate-show-negative-time-excel.html)

Ramonak

How do I calculate and show negative time in Excel?

I need to calculate and show lost time e.g
Expected arrival 1:15:00
Actual arrival 2:10:00
Time lost is Actual - Expected = -0:50:00

Gary''s Student

The calculation is working, the display is not working. Not your fault.
Try Tools Options... Calculate and then make sure the 1904 date
system is checked

Good Luck
--
Gary''s Student

"Ramonak" wrote:

I need to calculate and show lost time e.g
Expected arrival 1:15:00
Actual arrival 2:10:00
Time lost is Actual - Expected = -0:50:00

All times are GMT +1. The time now is 02:08 PM.