Timesheet calculator
Enter a start time, an end time and an unpaid break for each day. You get the hours worked for every day and for the week, as hours and minutes and as decimal hours. Overnight shifts work. With the example below, five days of 9:00 to 17:30 with a 30-minute break come to 40:00 hours.
Last reviewed October 19, 2026. What you type stays in your browser.
Your week
Type times as 9:00, 9am, 17:30 or 930. Leave a row empty to skip it. If the end is earlier than the start, the shift is read as ending the next day.
Hours and minutes40:00
Decimal hours40.00
Days counted5
Total 40:00 hours, 40.00 in decimal hours, across 5 days.
How the hours are worked out
For each day, hours worked = end time - start time - unpaid break. The week is the sum of the days. Decimal hours are the minutes divided by 60, so 7 hours 45 minutes is 7.75 hours. The calculator reads the clock as plain wall-clock time and does not know about time zones.
- Times can be 24-hour (17:30) or 12-hour (5:30pm). 12am is midnight and 12pm is noon.
- If the end is earlier than the start, the shift is read as ending the next day, and the row says so.
- If start and end are the same, the row counts as 0 hours and says so. For a 24-hour shift, use two rows.
- If the break is longer than the shift, the row shows an error and adds nothing.
- Break times are whole minutes. A fraction is rounded to the nearest minute.
Worked examples
| Shift | Hours and minutes | Decimal hours | Overnight |
|---|---|---|---|
| 9:00 to 17:30, 30-minute break | 8:00 | 8.00 | No |
| 8:00 to 17:00, 60-minute lunch | 8:00 | 8.00 | No |
| 9am to 5pm, no break | 8:00 | 8.00 | No |
| 22:00 to 06:00 overnight, 30-minute break | 7:30 | 7.50 | Yes |
| 12:30pm to 9:15pm, 45-minute break | 8:00 | 8.00 | No |
Rounding, if you need it
Rounding is off by default. If you turn it on, each day's worked total is rounded to the step you pick before the week is added up. This rounds the length of the day, not the clock-in and clock-out times.
Rounding up or down is a billing choice, for example billing clients in 6-minute increments. For hourly wages, the US Department of Labor's rule on rounding 29 CFR 785.48(b) accepts recording time to the nearest 5 minutes, tenth or quarter of an hour only if it does not, over time, leave employees underpaid. If you round for wages, use Nearest and check your own rules.
What this does not do
- It does not calculate overtime, pay, tax, meal-break rules or minimum wage. Those depend on where you work and your agreement.
- It does not know about daylight saving. On the night the clocks change, an overnight shift is an hour longer or shorter in real elapsed time than the clock difference shown here.
- For pay from hours, see the hourly rate calculator. For decimal hours and minutes, see the minutes to decimal converter.
Questions
How do I calculate hours worked?
Subtract the start time from the end time, then subtract any unpaid break. 9:00 to 17:30 is 8 hours 30 minutes between the times; with a 30-minute unpaid break it is 8 hours. This calculator does that for each day and adds the week.
How many hours is 9am to 5:30pm, or 8 to 5?
9am to 5:30pm is 8 hours 30 minutes, or 8 hours with a 30-minute unpaid break. 8am to 5pm is 9 hours, or 8 hours with an unpaid one-hour lunch.
What is the formula for working hours?
Hours worked = (end time - start time) - unpaid break. In a spreadsheet with the start in A2, the end in B2 and the break in minutes in C2, =(MOD(B2-A2,1)-C2/1440)*24 gives decimal hours, and MOD makes shifts that cross midnight work.
How are overnight shifts handled?
If the end time is earlier than the start time, the calculator reads the end as the next day. 22:00 to 06:00 is 8 hours, or 7 hours 30 minutes with a 30-minute break. The row is marked as overnight so you can check it.
What happens if the start and end are the same?
The row counts as 0 hours and a note says so, because there is no way to tell 0 hours from 24. For a 24-hour shift, enter two rows.
How do I show hours as a decimal?
Divide the minutes by 60 and add the hours. 7 hours 45 minutes is 7.75. 8 hours 20 minutes is 8.33 to two places (the exact value, 8 and a third, repeats). The minutes to decimal converter does it both ways.
How do I round time to the nearest 15 minutes?
Look at the minutes past the quarter hour. 1 to 7 minutes round down and 8 to 14 round up, because 7.5 is halfway. 8:07 becomes 8:00, 8:08 becomes 8:15 and 8:22 becomes 8:15. This calculator can round each day's total to 5, 6 or 15 minutes; if your employer rounds clock times instead, round the start and end times.
How do I round time to the nearest 5 minutes or the nearest hour?
Round to the nearest multiple of the step: to the nearest 5 minutes, 8:02 becomes 8:00 and 8:03 becomes 8:05; to the nearest hour, 8:29 becomes 8:00 and 8:30 becomes 9:00. In Excel or Google Sheets with the time in A2, =MROUND(A2,TIME(0,5,0)) rounds to 5 minutes and =MROUND(A2,TIME(1,0,0)) to the hour. The calculator's rounding box offers 5, 6 and 15 minutes for each day's total.
How do I convert work hours to work days?
Divide the total hours by the hours in a working day. 37.5 hours is 5 days at 7.5 hours a day, and 4.69 days at 8 hours a day.
Does it calculate overtime or pay?
No. Overtime depends on the job, where you work and your agreement; see the US Department of Labor's overtime guidance. The hourly rate calculator turns hours and a rate into pay figures.
Is anything I type saved or sent?
No. The times are worked out in your browser and are not sent to Honest Day or anyone else. The CSV is built in your browser too. The site records only that the calculator, print or download was used, never the times.
Related
Track the hours instead of adding them up.
Honest Day records time with a timer or a week grid, keeps the totals and builds invoices from them. Free for up to 5 members, no credit card.