How to use the Timesheet Calculator
Start with the settings that describe your pay period, then enter one row for each shift segment. The Timesheet Calculator keeps the entered date with each row, applies the break policy you choose, and groups the results by day and seven-day week.
- Set
Time zoneandWeek starts onfor these entries. - Choose a break policy and set
Daily overtime threshold (hours, 0 = off),Weekly overtime threshold (hours, 0 = off), andOvertime pay multiplier (informational). - Enter a date,
Start time,End time, and anyManual break (min; used with Manual policy)for each shift segment. ClickAdd shift rowfor another segment. - Click
Calculate timesheet, then review the per-shift, per-day, per-week, and total tables.
How the Timesheet Calculator calculates weekly hours
Each row uses elapsed time between Start time and End time. The calculator subtracts the break that applies to that row, then clamps paid hours at zero. For example, an 09:00 to 17:00 shift with a 30-minute break gives 7.50 paid hours.
8.00 gross hours - (30 minutes / 60) = 7.50 paid hoursRows are grouped by their entered date. The calculator finds daily overtime above the daily threshold, then places those dates into seven-day weeks beginning on Week starts on. It compares each week's paid total with the weekly threshold and limits final overtime to the paid hours in that week.
How breaks and shift times are interpreted
Select No automatic break - count all worked time as paid to deduct nothing. The automatic policy deducts the configured break only when a shift exceeds its threshold. Use the manual break minutes I enter on each shift row uses the minutes entered on that row.
For a split shift, add two rows with the same date. If End time is earlier than or equal to Start time, the row crosses midnight and receives the (+1 day) marker. Its hours remain assigned to the entered date for daily and weekly grouping. A break larger than the gross shift length leaves zero paid hours.
What the timesheet result includes
The result includes Formula used, Per shift segment, Per day, Per week, and Totals and assumptions. The tables show gross, break, paid, regular, and overtime hours. Use Copy result for the plain-text summary or Download result (.txt) to save a text file.
Every row needs a valid date, start time, and end time. Automatic break settings and overtime thresholds must be zero or greater. Manual break minutes must also be zero or greater when that policy is selected. If a required value is invalid, the calculator stops and shows an error. Thresholds are numeric comparisons; the calculator does not apply jurisdiction-specific labor, payroll, tax, or break rules.
Examples with dated shift rows
Enter morning and evening segments as separate rows when both belong to one date. Set Week starts on to the first day of the pay period, then inspect daily and weekly overtime in the result.
For an overnight shift, keep the start and end times on one row. When the end is earlier than the start, the result adds (+1 day) and still groups the row under its entered date.
When another date and time calculator fits better
This page belongs to Date and Time Calculators. Use the Timesheet Calculator for dated shifts, breaks, and overtime. Choose Work Hours Calculator for punch-time rounding or an optional gross-pay estimate.
Use Time Duration Calculator for elapsed time or duration arithmetic. Choose Date and Work Time Calculator when you need business days, date arithmetic, countdowns, ISO week numbers, and paid work-hour calculations together.
Frequently asked questions
How do I calculate weekly hours from a timesheet?
Enter each dated shift, choose the break policy and week start, then click Calculate timesheet. The result groups paid hours into daily totals and seven-day weekly totals.
How are overtime hours calculated on a timesheet?
Daily overtime is paid time above the daily threshold. After daily grouping, the calculator compares each week's paid total with the weekly threshold. Set either threshold to 0 to turn that comparison off.
Can a timesheet calculator handle overnight shifts?
Yes. An end time earlier than or equal to the start time is treated as a crossing-midnight shift and marked (+1 day). The row stays grouped under its entered date.
Does the Timesheet Calculator apply overtime laws?
No. It compares your entries with the daily and weekly thresholds you provide. It does not fetch jurisdiction-specific labor or payroll rules, and the calculation runs in your browser without sending shift data to a timekeeping or payroll service.