Plus what to do before you start
Calculate time difference in Excel between 2 times
When working on something like a timesheet in Microsoft Excel, you may need to know the difference between times. For example, you may enter a start time and an end time, where you want to see the number of hours worked.
We'll show you a few ways to find the difference between two times in Excel for project tracking, a work timesheet, or an employee schedule.
To correctly use the functions and formulas described here, you must use one of Excel's time formats for the time values in your cells.
