Difference between two times formula in Excel


In short, times in Excel are decimal numbers between 0 and 1 that show you the percentage of the day that has past. Now with that in mind let’s calculate two differences between Arrivals and Departures. Most Excel users will use a simple Arrival – Departure formula. But things can go very wrong if you use that formula. Let’s look at two samples of time in Flight calculation.

So if you calculate the difference between 10:00 AM (Departure) and 6:00 PM (Arrival) with the =6:00 PM – 10:00 AM you are actually calculating the difference between 0.75 and 0.416666666666667 and you get 0.333333333 which is 1/3 of a day or 8 hours.

But here’s a problem. Let’s say that those times are 10:00 PM (Departure) and 3:00 AM (Arrival). For Excel those are 0.916666666666667 and 0.125. And if we follow our formula (=Arrival – Departure) we get -0.791666666666667 or -19…

View original post 156 more words