Calculating time difference through midnight in Excel

Home / Excel / Calculating time difference through midnight in Excel

All Tricks and formula failed when you wanted to do time difference for midnight .. mostly questions arise like

“How do I calculate the time duration in minutes between two times when the first time is before midnight and the second time is after midnight?

And solution is :

B2 cell contain value : 23:00
C2 cell contain value : 1:37
Formula is D2: =C2-B2+(B2>C2)

Why it works, time is a fraction of a day, the comparison B2>C2
returns True (1) or False (0), if true 1 day (24 hours) is added.

edgedoll.com

Comments(0)

Leave a Comment