Money & shopping

Timesheet hours calculator

Add work intervals and unpaid breaks from a local CSV.

Timesheet hours calculator
Esc to restore

Your inputs

Use the exact example headings. UTF-8 CSV/TSV stays local; maximum 25 MB.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Calculates local wall-clock minutes between Start and End, subtracting the supplied break. An end earlier than start means one overnight interval; equal times mean zero elapsed time. Requires valid Gregorian dates and HH:MM times, with breaks no longer than the interval. Ignores time-zone/DST transitions, overtime, rounding policies and employment entitlements.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

CSV: Date,Start,End,Break minutes
Date,Start,End,Break minutes
2026-01-05,09:00,17:30,30
2026-01-06,09:00,17:00,30
Optional hourly cost rate in one currency
20

Example result

Example result
Starting dateStartEndBreak minutesNet hoursModelled cost
2026-01-0509:0017:30308160
2026-01-0609:0017:00307.5150

Modelled cost 310.00 at the supplied hourly rate. Wall-clock arithmetic; no DST, overtime or entitlement rules.

Keep going.

Bill splitterUnit price calculatorMargin & markup calculatorBreak-even calculator