Weekly timesheet calculator
Weekly hours from start, end and break per shift, with overtime and gross pay.
Fill in the fields and the result will appear here automatically.
A timesheet is settled for the whole week rather than a single shift, and that is exactly where minutes go missing: a forty-five minute break here, a shift running past midnight there, a short day at the end. Each shift is one line, the total is accumulated in whole minutes and converted to hours only once — so the sum matches the paper sheet. A line such as 22:00,06:00 is understood as crossing midnight, not as an error. This records clock readings without dates or time zones. Pay uses the entered standard hours and a fixed 1.5 multiplier for every hour above them; it does not determine legal overtime, night premiums or contract-specific rules.
How it works
Formula and logic
Each row has exactly start,end or start,end,break. Times use HH:MM; breaks are whole nonnegative minutes, with blank meaning 0. An end earlier than the start adds 1440 minutes; equal start and end mean 0 rather than 24 hours. Minutes are summed exactly. Pay = min(hours,standard)×rate + max(hours−standard,0)×rate×1.5. Standard hours may be fractional. Daylight-saving changes and shifts longer than a day are not modelled.
Example
Five shifts with breaks add up to 36.75 hours and 18,375 at a rate of 500 per hour. Row 22:00,06:00,30 gives 7.5 hours; equal start and end with no break give 0 hours.
Fields and units
- Shifts: start, end, break in minutes — start and end HH:MM; break in minutes
- Hourly rate — $
- Standard hours for the period — h
How to use
- — One shift per line: start, end and break in minutes separated by commas.
- — The break may be omitted: a line of 09:00,18:00 counts as a shift with no break.
- — A night shift is written as it is: 22:00,06:00 is read as crossing midnight.
- — Anything above the standard hours goes to overtime at one and a half times the rate.
- — Enter only breaks to be excluded, in whole minutes. For other pay multipliers, use the resulting hours and a separate payroll calculation.
Method and limitations
- Calculation method
- Formula and logic
- Data or methodology source
- US DOL Fact Sheet 23: bounded US coverage of the 1.5× rule; not worldwide payroll calculation
- Limitation
- Clock hours without dates or DST; fixed 1.5 pay above the entered standard. Not a legal calculation of required wages.
FAQ
Why count in minutes rather than hours?
A shift of 8 hours 45 minutes is 8.75 hours, one of 7 hours 20 minutes is 7.333…. Adding such fractions and rounding each on the way loses minutes; in whole minutes the total is exact.
How do I enter a night shift?
As an ordinary line: 22:00,06:00. When the end is earlier than the start, the shift is treated as crossing midnight and a day is added to the end.
Where does the 1.5 multiplier come from?
It is fixed in this teaching model for all hours above your entered standard. It is not a statutory payroll calculation: rules may distinguish days, types of hours, rates and exceptions. Use the hour totals and calculate pay separately if your rules differ.
What if the break is longer than the shift?
That line is rejected. Negative working time means a typo in the times or in the break, and silently turning it into zero would be worse than saying so.