Time Duration Calculator
Enter a start and end time to get the duration in hours and minutes, decimal hours and total minutes. Add dates for longer spans and subtract a break.
Without dates, an end time earlier than the start time is counted as the next day, so a night shift works.
Do this inside Excel and Google Sheets with AI.
CoreGPT writes formulas, cleans columns and compares data right in your spreadsheet. Ask in plain English.
This calculator works out how long it is from one time to another: a shift, a meeting, a flight, a project. It shows the answer as hours and minutes, as h:mm, and as decimal hours, which is the form timesheets and payroll use (7 h 30 min is 7.5 hours). Leave the dates empty for a same-day or overnight span, or add them to measure several days. A break in minutes is subtracted from the total.
- Working out hours worked for a timesheet
- Billing a client for time spent
- Checking the length of a meeting, class or event
- Measuring the time between two dates and times
- Converting hours and minutes into decimal hours for Excel
- Use decimal hours when you multiply by an hourly rate
- For overnight shifts, leave the dates empty or enter both dates
- Enter unpaid breaks so the result is paid time
- In Excel, subtract the two cells (=B2-A2) and format the result as [h]:mm to get the same answer
- To get decimal hours in Excel, multiply the difference by 24
How do I calculate the hours between two times?
Enter the start and end time. The calculator subtracts them and shows the hours and minutes, plus the decimal value.
How do I convert minutes to decimal hours?
Divide the minutes by 60. 45 minutes is 0.75 hours, so 7 h 45 min is 7.75 hours. The calculator shows this for you.
Does it handle times past midnight?
Yes. If the end time is earlier than the start time and no dates are set, it is treated as the next day.
How do I do this in Excel?
Put the start time in A2 and the end time in B2, then use =B2-A2 and format the cell as [h]:mm. For overnight shifts use =MOD(B2-A2,1).