It’s common to need to calculate the difference between dates/times in Excel—whether you’re figuring out how long someone worked on a given day, or the duration of travel across multiple days.
In a hands-on tutorial, I’ll show you five different examples of how to work with time in Excel.
00:00 – Example #1: Calculate amount of time worked using H:MM format, Military Time
01:26 – Example #2: Calculate amount of time worked using H:MM format, AM-PM
02:33 – Example #3: Calculate amount of time worked in decimal numbers
03:44 – Example #4: Calculate amount of time worked in full hours, using the TEXT function
04:44 – Example #5: Calculate time duration across multiple dates, in hours, minutes, seconds
