Forum Discussion
Solved
Calculate difference between two times in Excel for Mac
I had to separate the times from the date columns that were formatted as date and time. After I separated out the times, I applied the simple formula =N2-O2 to calculate the time differential. But, i...
Hi Hugh,
If negative elapsed time is the case you may use text to show it
=IF(H2-G2 <0, "-" & TEXT(G2-H2, "[HH].mm.ss"), H2-G2)
more details at
https://excelribbon.tips.net/T006239_Displaying_Negative_Times.html
Please see file attached
As far as I recall one can present Negative time in Excel for Mac.
Goto Tools > Options > Calculation > mark 1904 date system.
This should enable the presentaion of negative times.
-----------------------
Michael (Micky) Avidan
Yes, that works. But, IMHO, with formula is more safe.