How Timesheet Calculator works
This timesheet calculator turns a list of clock-in and clock-out times into total hours worked, per shift and across however many days you enter, automatically subtracting unpaid break time. Add an hourly rate and it converts the total straight into gross pay. It reads plain text — one shift per line — so pasting a week's worth of punch times in from wherever they're recorded takes seconds rather than manual subtraction for each day.
Step by step
- 1
List each shift as day, start time, end time and break minutes, one per line.
- 2
Use 24-hour time for the start and end (09:00, 17:30).
- 3
Optionally enter an hourly rate to calculate gross pay.
- 4
Read the per-shift breakdown and the weekly total.
How overnight shifts are handled
If a shift's end time is earlier than its start time — 22:00 to 06:00, for instance — the calculator assumes the end time falls on the following day rather than treating it as a negative or invalid duration, correctly returning 8 hours for that example rather than an error.
Why break time is subtracted separately
The raw span between clock-in and clock-out usually includes unpaid break time that shouldn't count toward hours worked or pay. Entering it as its own field, rather than expecting it already excluded from the start and end times, matches how most time-clock systems record a shift and avoids the common error of forgetting to dock the lunch break by hand.
When you would reach for this
Freelancers billing by the hour
Total up a week of logged start and end times before invoicing a client, without adding minutes by hand across several days.
Checking a payslip against your own records
Recreate the week from your own notes and compare the total hours against what actually appeared on a payslip.
Part-time and shift work with irregular hours
Total up a week where every shift starts and ends at a different time, including an overnight shift that crosses midnight.
Worth knowing
- Enter times in 24-hour format — 17:30, not 5:30 PM — since that's the only format the calculator recognises.
- Leave the break field blank or at 0 for a shift with no break rather than omitting the field entirely.
- This tool applies one flat hourly rate to every hour; for roles with a separate overtime rate, calculate the regular and overtime portions as two separate totals and add them together.