StatGardenREF. DESK
Calculators/Date & time/Timesheet & pay
Date & time

Timesheet & pay calculator

Hours worked in a shift and what they are worth.

What this calculator does

Timesheet & pay works out hours worked in a shift and what they are worth. Enter your own figures above and the answer updates as you type: nothing is fixed in the code, so the result reflects exactly the numbers you supply.

The formula this calculator evaluates is printed under the tool and explained below, so you can check the working by hand or reuse it in a spreadsheet.

The formula

FormulaHours = (finish − start) − break; Pay = ordinary hours × rate + overtime × rate × multiplier

The inputs explained

FieldWhat to enter
Start timeA time of day, in 24-hour format.
Finish timeA time of day, in 24-hour format.
Unpaid break (minutes)A number, measured in minutes. Starts at 30.
Days workedA number. Starts at 5.
Hourly rate ($)A number, measured in your currency. Starts at 35.
Hours before overtime starts (per day)A number. Starts at 8.
Overtime multiplierA number. Starts at 1.5.

Worked examples

Every figure in the tables below is produced by this page’s own calculator at build time, so the numbers and the tool always agree. Select any row to load that scenario.

How the answer changes with unpaid break

Every other input is held at the calculator’s starting values while unpaid break varies. Select any row to load that scenario into the calculator.

How the answer changes with unpaid break
Unpaid break (minutes)Hours per dayDaily payTotal hours
158.25$293.1341.25
22.58.13$286.5640.63
308.00$280.0040.00
457.75$271.2538.75
607.50$262.5037.50
907.00$245.0035.00