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
Thank you, Sergei!
Any suggestions as to how to deal with the ones that arrived earlier than scheduled? The other ones worked perfectly.
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