Timesheet Calculator

A week of in/out times → hours and gross pay, overnight-safe.

The formula behind it

daily hours = (end − start) − break • weekly gross = rate × regular + rate × multiplier × OT
start/end
clock-in and clock-out per day; end before start counts as overnight
threshold
weekly hours where overtime begins

Enter each day's clock times and break; the sheet totals daily and weekly hours, handles overnight shifts as spanning midnight, then applies your overtime threshold and multiplier for gross pay. Invalid times like 99:00 are rejected rather than silently producing nonsense.

How to use this calculator

  1. 1

    For each day worked, enter clock-in, clock-out and unpaid break minutes.

  2. 2

    Enter your rate, weekly OT threshold and multiplier.

  3. 3

    Read daily hours, the weekly total and gross pay.

Worked examples

Three shifts, one overnight

Mon–Wed 9–5 with breaks plus Fri 22:00→06:00 → 23 h total; overnight day shows 8 h and the total gross follows your OT rules.

One 8.75-hour Monday with a 45-minute break

09:00–17:30 minus 45 minutes = 7.75 paid hours → $170.50 at $22/h, all regular because the 40-hour overtime threshold is untouched.

Frequently asked questions

Explore more categories

Command Palette

Search for a command to run...