Calculate timesheet

Total clock-in rows, unpaid breaks, threshold hours, and time-and-a-half payable hours.

freeworks offlinenothing uploaded
ToolTimesheet Calculator
Input
Output
—
Put this on your own site

The frame below runs the same code as this page, in the reader's own browser. Nothing is sent to us, and nothing is sent to you.

Pick a dark background and the text and panels follow it, so the frame stays readable on a dark page.

Preview

How it works

HH:MM values become minutes since midnight; an end at or before its start crosses into the next day, then break minutes are removed. Period minutes split at the selected threshold and only the payable total multiplies overtime by 1.5.

  • Forty hours is an editable familiar weekly threshold, not a claim about a contract or local employment law.
  • A missing third row value means zero break minutes.

Worked example

A working week with overtime
Five nine hour shifts against a forty hour week
Input
											09:00-18:00,09:00-18:00,09:00-18:00,09:00-18:00,09:00-18:00
Output
												Shifts count: 5
Total hours: 45
Regular hours: 40
Overtime hours: 5
Payable hours: 47.5

When to use this

Employees compare weekly rows with payslips, contractors total overnight support, and managers inspect how a chosen threshold divides regular and premium time.

Edge cases

  • 22:00–06:00 is eight overnight hours rather than negative sixteen.
  • 09:00–09:00 is defined as a 24-hour shift, not zero.
  • A break longer than its shift is rejected instead of producing negative work.