Account

What new tool do you want?

Business & E-commerce

Weekly Timesheet Calculator

Add up a week of start and end times with breaks, get total hours in hours:minutes and decimal, and calculate pay with overtime over 40 hours.

How to use

  1. 1Enter each day as 'start end break-minutes' (e.g. '9:00 17:30 30'); leave days off blank.
  2. 2Enter your hourly rate and overtime threshold to see pay.

How it's calculated

Daily hours = end − start − break (overnight shifts wrap past midnight). Overtime = weekly hours above the threshold, paid at the overtime multiplier.

Frequently asked questions

How do I enter an overnight shift?

Just enter the times, e.g. '22:00 6:00 30' — when the end is earlier than the start it's counted as the next morning.

Is overtime daily or weekly?

Federal US law uses weekly overtime over 40 hours. Some states (like California) also have daily overtime — check your local rules.

How are decimal hours calculated?

Minutes ÷ 60: 7 hours 45 minutes is 7.75 hours.

Why overnight shifts need a trick, not a different formula

A shift entered as '22:00 6:00' would normally compute as negative hours, since 6:00 comes before 22:00 on a 24-hour clock — the calculator detects that the end time is earlier than the start and adds 24 hours (1,440 minutes) to it, treating the end time as belonging to the next calendar day without needing a separate overnight-shift mode.

Worked example: Weekly Timesheet Calculator

A shift of '22:00 6:00 30' (a 30-minute break) computes as: start 22:00 = minute 1,320, end 6:00 treated as minute 1,800 (6:00 + 1,440), minus the 30-minute break, giving 1,800 − 1,320 − 30 = 450 minutes, or 7.5 hours. Across a standard Monday–Friday week of '9:00 17:30 30' each day, five days at 8 hours each totals 40 hours exactly — right at the overtime threshold, so none of it counts as overtime in this calculator's default settings.

Overtime rules aren't the same everywhere

This calculator applies overtime only after a single weekly hours threshold, matching US federal law's 40-hour standard — but several US states (California among them) also require daily overtime after 8 hours in a single day, which this tool doesn't separately track. If your jurisdiction has daily overtime rules, check each day's hours against that threshold by hand in addition to the weekly total shown here.

Why this tool doesn't round times the way some payroll systems do

Some employers round punched times to the nearest 5, 6 or 15 minutes using rules like the common '7-minute rounding' convention, which can nudge recorded hours slightly up or down from the exact clock times entered. This calculator always computes exact minutes from whatever start and end times you type in, with no rounding applied — a useful baseline for checking a timesheet, but worth comparing against your employer's specific payroll rounding policy if the two don't match exactly, since a consistent rounding rule applied over many pay periods can add up to real money in either direction — an employee who regularly clocks in a few minutes early and out a few minutes late might reasonably expect a rounding policy to favor them roughly as often as it rounds against them.

A shift that ends earlier than it starts is treated as overnight

Each day is a start, an end, and a break in minutes, and a blank day is skipped. If the end clock time is earlier than the start, a full day is added to the end before the break comes off, which is how a shift past midnight still counts. If the break is longer than that span, that day is rejected by name. Overtime is the weekly total above the threshold, which opens at 40, paid at the multiplier, which opens at 1.5, and the rest is paid at the plain rate. Minutes are not snapped to the nearest quarter hour. The hours line keeps two decimals and a hint in hours and minutes.

Related tools

More: Business & E-commerce