Timesheet and pay calculator
Decimal hours and hours-and-minutes are different notations, and payroll wants the decimal one.
hours a week
Gross weekly pay
942.19
- Hours in the week
- 41.250
- Paid hours per day
- 8.2500
- Paid time per day
- 8:15:00
- Overtime hours
- 1.250
- Pay at the basic rate
- 900.00
- Overtime pay
- 42.19
- Annualised gross
- 49 162.00
Show the working
- Hours worked = 8
- Plus minutes = 45
- Days worked = 5
- Hourly rate = 22.5
- Overtime starts after = 40
- Overtime multiplier = 1.5
- Unpaid break per day = 30
- Paid hours per day = 8 + 45/60 - 30/60 = 8.25
- Hours in the week = 8.25 * 5 = 41.25
- regular = min(41.25, 40) = 40
- Overtime hours = max(41.25 - 40, 0) = 1.25
- Pay at the basic rate = 40 * 22.5 = 900
- Overtime pay = 1.25 * 22.5 * 1.5 = 42.1875
- Gross weekly pay = 900 + 42.1875 = 942.188
- Annualised gross = 942.188 * 52.17857142857143 = 49 162
- Paid time per day = 8.25 * 3600 = 29 700
Values are shown to six significant figures here; the arithmetic itself runs on exact fractions and is only rounded where a number is printed.
Scenarios & local history
Compare a saved scenario
Recent calculations
The formula
- decimal hours = hours + minutes / 60
- overtime = hours above the threshold, paid at the multiplier
45 minutes is 0.75 hours, not 0.45. Getting that wrong is the most common timesheet error there is.