Timesheet Calculator screenshot

Timesheet Calculator

Add up shifts from start, end and break times, with overnight rows and a weekly total in decimal hours.

Privacy First
0 Runs
Updated 2026-11-07
Runs in your browser
No account
Nothing is sent

Add up a week of shifts

Each row takes a start time, an end time and a break in minutes. Times are 24-hour H:MM. An end earlier than the start is read as the next day, so 22:00 to 06:00 is eight hours. The break is subtracted and a row is clamped at zero.

The page reports each row's decimal hours and the weekly total. Decimal hours are minutes divided by 60, rounded to two places.

The arithmetic is wall-clock subtraction: there is no time-zone or daylight-saving conversion, no overtime rate and no automatic lunch deduction. Every break has to be entered.

This page adds up shifts. Each row takes a start time, an end time and a break in minutes, and returns the row's hours plus the weekly total in decimal hours. Add or remove rows as the week needs.

Times are 24-hour H:MM. An end earlier than the start is read as the next day, so an overnight shift is one row rather than a negative one. The break is subtracted, and a row cannot go below zero.

The arithmetic is wall-clock subtraction in the tab: no time zone, no daylight-saving conversion and no calendar. Decimal hours are minutes divided by 60 and rounded to two places, which is the form a payroll sheet usually wants.

How one row becomes hours

The page converts both times to minutes since midnight. If the end is later, it subtracts the start; if the end is earlier, it adds a day first. An end equal to the start counts as zero, because a row with no elapsed time is more likely a typo than a 24-hour shift.

The break is then subtracted and the result clamped at zero. A 30-minute break on an 8.5-hour shift leaves 8 hours; a 60-minute break on a 30-minute row leaves zero rather than negative time.

  • Minutes = (end − start + 1440) mod 1440, then subtract the break
  • Decimal hours = minutes / 60, rounded to two places
  • Weekly total = the sum of every valid row

What the total does not include

The weekly total is the sum of the rows on the page. There is no paid/unpaid distinction, no overtime multiplier, no rounding to the nearest quarter hour and no automatic lunch deduction — every break has to be entered on its row.

Because the page never converts a time zone, a shift that crosses a daylight-saving change is not adjusted. The wall-clock difference is what is shown, and a payroll figure that depends on the clock change has to be checked against the source record.

How to use the shift rows

Press Add a row for each shift, then enter Start and End in 24-hour H colon MM with the Break in minutes for that row. An end earlier than the start reads as the next day, so an overnight shift is one row; the Weekly total sums every valid row in decimal hours as you type.

Times are wall-clock subtraction only: no time zone and no daylight-saving conversion. A break longer than its row clamps that row at zero, an invalid time marks the row and is excluded, and Remove deletes a row from the total.

What to Expect

Best for

  • Adding up a week of shifts from a rota
  • Turning start and end times into decimal hours
  • Recording an overnight shift as one row

Not ideal for

  • Overtime rates, premiums or pay calculations
  • Time zones and daylight-saving adjustment
  • Automatic lunch or break deduction from a policy

What this tool keeps

  • Each row's minutes and decimal hours, separately
  • The weekly total even when one row is invalid (it contributes zero)
  • Your rows until the page is reloaded

What may need cleanup

  • An invalid time, which marks the row and is excluded from the total
  • A break longer than the shift, which reads as zero hours
  • A daylight-saving boundary, which is not converted

Common errors

  • Entering a 12-hour clock time without AM or PM
  • Forgetting the break on a row that had one
  • Expecting the page to round to a payroll increment

Example use cases

  • Totalling a week of restaurant shifts
  • Converting a night shift into decimal hours
  • Checking a timesheet against a rota

Sample input

A 09:00–17:30 row with a 30-minute break, plus a 09:00–13:00 row with no break.

Sample output

Eight hours on the first row, four on the second, twelve decimal hours for the week.

Who this is for

  • Shift workers checking their own hours
  • Small employers adding up a rota
  • Anyone converting clock times to decimal hours

Frequently asked questions

Does an end time before the start time mean a mistake?

No. It is read as the next day, so 22:00 to 06:00 counts as eight hours rather than minus sixteen. A start equal to the end counts as zero minutes.

What happens if the break is longer than the shift?

The row is clamped at zero minutes. The page does not show negative hours, and the weekly total includes zero for that row.

Does the page know about time zones or daylight saving?

No. It subtracts two wall-clock H:MM times and never converts a zone, so a shift spanning a daylight-saving change needs the hours confirmed by hand.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.