Using the Timesheet Calculator
Enter a date, start time, end time, and any applicable break minutes for each shift. Choose the calculation rules, then click Calculate timesheet. The result shows paid hours per shift, day, and week, daily and weekly overtime, the formula used, and the assumptions behind the totals.
Set the calculation rules
Set these controls before entering or calculating shifts:
- Time zone: interprets each entered clock time as wall-clock time in the selected zone.
- Week starts on: groups entries into consecutive 7-day blocks beginning on the selected weekday.
- Break rule: choose no automatic break, an automatic unpaid break after a configured shift length, or manual break minutes per row.
- Daily overtime threshold (hours, 0 = off) and Weekly overtime threshold (hours, 0 = off): set the numeric thresholds used for overtime.
- Overtime pay multiplier (informational): produces an hour-equivalent in the result. It does not calculate monetary pay.
Enter shifts, split shifts, and overnight shifts
- Use one row for each shift segment. Click Add shift row for more rows.
- For a split shift, enter multiple rows with the same date.
- If the end time is earlier than the start time, the shift crosses midnight. An end time equal to the start time also becomes a 24-hour crossing-midnight shift.
A crossing-midnight row is marked (+1 day), but it remains grouped under its entered shift date for daily and weekly totals.
How the overtime calculation works
For each row, paid hours are gross elapsed hours − (break minutes ÷ 60), with a floor of zero. The calculator then applies overtime in stages:
- It sums paid hours by the entered shift date and calculates daily overtime first when the daily threshold is above 0.
- It combines each day's regular hours and daily overtime into the week's paid total.
- When the weekly threshold is above 0, it calculates preliminary weekly overtime from the combined weekly total above that threshold.
- It limits final overtime to the available combined hours, so daily and weekly overtime are not counted beyond the same hours twice.
- It calculates regular hours as total paid hours minus final overtime.
Calculate and read the result
Click Calculate timesheet. Review the headline totals and the sections Formula used, Per shift segment, Per day, Per week, and Totals and assumptions. The tables include gross hours, break time, paid hours, daily overtime, regular hours, overtime hours, and the selected settings.
Use Copy result for a plain-text summary on the clipboard, or Download result (.txt) to download that summary.
Validation and limitations
Each row needs a valid date, start time, and end time. Manual break minutes and overtime thresholds must be zero or greater. If validation fails, calculation stops and shows a specific error; invalid rows are not silently skipped.
The calculator performs numeric comparisons using the thresholds you enter. It does not fetch jurisdiction-specific labor, break, overtime, minimum-wage, payroll-tax, tax-withholding, net-pay, time-clock, or payroll-system rules. Treat the result as arithmetic for review, not legal or payroll advice.
Privacy and calculation location
Calculations run in your browser using the values you enter. The tool does not upload shift data or query external timekeeping or payroll services. This describes the calculator's data processing, not every request made by the surrounding page.
Frequently Asked Questions
Does this calculator know my state's or country's overtime laws?
No. It does not fetch or apply any jurisdiction's labor law, minimum-wage rule, or payroll tax rule. Overtime is plain arithmetic against the daily and weekly hour thresholds you type in yourself. Treat the result as a starting point, not legal or payroll advice.
How are breaks subtracted from a shift?
You choose one break rule for the whole timesheet: no automatic break, an automatic unpaid break once a shift passes a length you set, or the manual break minutes you type on each row. Paid hours for a shift are gross hours worked minus whichever break minutes apply.
Can I enter a split shift or an overnight shift?
Yes. Add two rows with the same date to represent a split shift on one day. If an end time is earlier than or equal to the start time, the calculator treats the shift as crossing midnight into the next day. It keeps the shift grouped under the entered date for daily and weekly totals.
What day does the week start on?
Whichever day you choose in the week-start setting. Weekly totals and weekly overtime are grouped into 7-day blocks starting on that weekday, not a fixed calendar convention, so you can match your employer's actual pay-period start.
Where does the calculation happen?
The calculation runs in your browser using the values you type in. The tool does not upload shift data or query external timekeeping or payroll systems.