Timesheet Calculator: Weekly Hours
Add up a week of shifts, with breaks, in hours and minutes and decimal hours.
Good to know. Five days of 7 h 45 min is 38.75 hours, not 38.45. Minutes are sixtieths, not hundredths.
How it works
In plain words
For each day, subtract the start time from the end time (adding 24 hours if the shift runs past midnight) and take off the break. Add the days together. Divide the minutes by 60 for decimal hours.
The formula
day = end − start (+ 24 h if end < start) − break week = Σ days decimal hours = minutes ÷ 60
Worked example
Monday and Tuesday are 8 h each, Wednesday 7 h 30, Thursday 8 h 15 and Friday 6 h: 37 h 45 min in total, or 37.75 decimal hours.
Sources
No outside data or rates: this is plain arithmetic.
8 automated tests check its answers on every change.
About the timesheet calculator: weekly hours
Filling in a timesheet by hand means adding up hours and minutes, which is where most mistakes happen. Type one line per day with the start time, the end time and any unpaid break in minutes, and the calculator adds up the week in hours and minutes and in decimal hours.
Decimal hours are what most payroll systems use. The trap is that minutes are sixtieths of an hour, not hundredths: 7 hours 45 minutes is 7.75 hours, not 7.45. The table below the result shows each day in both forms, so you can copy the one your employer asks for.
Times can be written as 24-hour (17:30) or with am and pm (5:30pm), and you can start each line with the day’s name or leave it out. A shift that ends before it starts, like 22:00 to 06:00, is counted as running past midnight. Paid breaks can simply be left out.
Add your hourly rate to see the week’s pay. The pay here is at a flat rate; if hours over 40 are paid at time and a half, use the overtime pay calculator with the “hours over 40” figure. All pay is before tax.
Questions people ask
How do I calculate hours worked in a week?
Work out each day as end time minus start time minus unpaid breaks, then add the days together.
How do I convert hours and minutes to decimal hours?
Divide the minutes by 60 and add them to the hours. 37 h 45 min is 37.75 hours.
Can I use am and pm?
Yes. Write times like 8:30am and 5pm, with or without a space.