Skip to content
Date & TimebusinessUnited States only

Timesheet and Hours Worked Calculator

A weekly timesheet with breaks deducted and overtime split out. Breaks come off before the overtime threshold is tested, which is what decides whether a week crosses it, and 8 hours 15 minutes is 8.25 decimal hours rather than 8.15.

Also called: weekly timesheet calculator, work hours calculator.

$
Hours worked
37.75

37.75 hours across 5 days after 3.75 hours of unpaid breaks. That is 37.75 at the regular rate and 0 at overtime, paying $830.50. Minutes are sixtieths, so a quarter hour is 0.25 decimal hours rather than 0.15. Payroll wants the decimal figure.

Regular hours
37.75
Overtime hours
0
Unpaid break hours
3.75
Days worked
5
Regular pay
$830.50
Overtime pay
$0.00
Total pay
$830.50
Average day length
7.55
In hours and minutes
37 hours 45 minutes
On decimal hours
Minutes are sixtieths, so a quarter hour is 0.25 decimal hours rather than 0.15. Payroll wants the decimal figure.
How this is calculated
Method and background

How this is calculated

Each day contributes its hours less the unpaid break, and only days with hours logged take a break deduction. The order matters: deducting breaks before testing the overtime threshold can put a week that looked like overtime back under it, which is how payroll and the employee reach different numbers from the same times. Decimal conversion is the other quiet error, since minutes are sixtieths and a quarter hour is 0.25 rather than 0.15.

breaks come off before the overtime threshold is tested, which decides whether the week crosses it at all
r
Hourly rate
m
Overtime multiplier

Worked examples

Each of these is asserted on every build. If a change to the engine ever moved one of these answers, the build would fail before the page could print it.

a five day week with breaks

Monday hours
8.5
Tuesday
8.5
Wednesday
8
Thursday
9
Friday
7.5
Saturday
0
Sunday
0
Unpaid break each worked day
45
Hourly rate
$22.00
Overtime after this many hours a week
40
Overtime multiplier
1.5

Hours worked37.75

41.5 clock hours less 3.75 of unpaid breaks is 37.75, which keeps the week under the 40-hour FLSA threshold, so all of it pays at 22: 830.50. Worked by hand.

Open this example

a six day week crosses into overtime

Monday hours
9
Tuesday
9
Wednesday
9
Thursday
9
Friday
9
Saturday
6
Sunday
0
Unpaid break each worked day
30
Hourly rate
$22.00
Overtime after this many hours a week
40
Overtime multiplier
1.5

Hours worked48

boundary: 51 clock hours less 3 of breaks is 48, so 8 hours over the threshold at 22 x 1.5 = 33, which is 264. Deducting breaks before testing the threshold is what decides this, and doing it the other way round would have paid overtime on 11 hours.

Open this example

Method and limits

What it assumes

  • A weekly overtime threshold. Some jurisdictions use a daily one instead.

What it deliberately does not model

  • Daily overtime rules, common in parts of the US, are not modelled.
  • Statutory overtime multipliers and thresholds vary and are inputs here rather than lookups.
  • Night shift and public holiday premiums are separate from overtime.

Formula version 1.0.0 · definition 1.0.0 · United States · Report a problem with this calculator

Frequently asked questions

Why is 8 hours 15 minutes not 8.15?
Minutes are sixtieths rather than hundredths, so a quarter hour is 0.25. Entering 8.15 on a timesheet records nine minutes instead of fifteen and underpays.
Do breaks come off before or after overtime is calculated?
Before. Unpaid breaks are not worked time, so a week that looks like overtime on clock hours can fall under the threshold once they are deducted.