Excel How ToLesson 123Free preview

Difference Between Times

This lesson is part of Excel · All levels

Summary

The time difference between two is calculated by subtracting one time value from the other value. The result is a fraction of a day that can be formatted as a clock. When the range passes through midnight, use MOD to keep the results positive.

Key points

The basic difference: =B1-A1 and then formatted as [h]:mm
One full day is worth 1, so 0.25 is six hours.
Dealing with the midnight shift.
Format [h]:mm displays hours over 24 hours

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.