How to use Hours Worked Calculator
- Enter one shift per row as start time, end time and optional unpaid break in minutes. For example, 09:00 17:30 30 means an eight-hour paid total.
- Add the other shifts. Times accept 24-hour or AM/PM form; an end earlier than the start is treated as the following day.
- Choose hours and minutes, decimal hours or both. Optionally enter a gross hourly rate and a threshold for comparing the total.
- Review each shift and the total as the rows update. Export the CSV if you need to move the calculation into a timesheet.
Example: Hours Worked Calculator
Three shifts, including an overnight shift, total 23 hours and 15 minutes.
Options
- Shift lines
- Each line holds a start time, an end time and an optional unpaid break in minutes. Times accept the 24-hour clock or AM/PM. When the end time is earlier than the start time, the shift finishes the next day.
- Output format
- Hours and minutes keep the total readable, decimal hours suit a spreadsheet, and the combined option prints both. The exact total in minutes is always shown with the result.
- Gross hourly rate (optional)
- Multiplies the elapsed hours by this entered rate. No tax, deductions or legal pay rules are applied.
- Compare against this many hours (optional)
- Reports how many hours sit above the threshold you enter. This is a comparison you enter, not an overtime rule.
Supported inputs and limits
- Up to 31 shifts, with zero to 720 whole unpaid-break minutes per shift.
- A break must be shorter than its shift; equal start and end times are rejected.
- Rows contain clock times without dates or zones, so daylight saving changes are not measured.
- The five-shift helper supplies example rows without weekday names.
- Gross pay uses only the entered rate.
More details
Tax, deductions, overtime law, rounding policies and holiday rules are not applied; hours above a threshold are only a comparison.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Read decimal hours as a duration
The tool adds each shift in whole minutes before converting the total to decimal hours. A result of 7.5 hours means 7 hours 30 minutes, not 7 hours 50 minutes. Because rows contain no dates or zones, an overnight shift is measured from the clock readings alone; a real shift crossing a daylight saving change may have a different elapsed duration.
Questions about Hours Worked Calculator
How do I record an overnight shift?
Write the start and end times as they appear on the clock, such as 22:00 06:00, and the tool adds the hours across midnight. Any end time earlier than the start time is treated as the next day.
What does the third number on a line mean?
It is the unpaid break in minutes. 09:00 17:30 30 means a half-hour break, and a line with only two times has no break at all.
Does the total account for overtime or pay?
An optional hourly rate gives a gross pay estimate from the total hours. It excludes tax and deductions. Hours above an entered threshold are a comparison, not a legal overtime determination; payroll multipliers and rounding rules are not applied.
Can I paste rows from a spreadsheet?
Yes, as long as each row keeps the start time, the end time and the optional break together. Spaces, tabs and commas all separate the values.