Shift and overtime calculator with payroll CSV

Yes. When the finish time is earlier than the start time the shift is treated as crossing into the next day, so 22:00 to 06:00 is eight hours. This is the normal case for shift work, and it is where hastily written calculators produce negative numbers.

Anything past the daily threshold you set is paid at the overtime multiplier. Rest days and public holidays are paid at their own multiplier for the whole shift instead, which is how most rest-day rules are written — the day itself is the premium.

Payroll systems take 7.40, people read 7h 24m. Converting by hand is where mistakes creep in, so the CSV carries both.

No. Shifts and rates stay in your browser using local storage, so the list survives closing the tab. Nothing is sent anywhere, and clearing your browser data removes it.

Only if the multipliers you enter match it. Overtime rules, rest-day premiums and holiday rates differ by country and often by contract, which is why every rate here is editable rather than fixed. Check the figures against your own terms.

Native time pickers vary a lot between browsers and phones, and several make entering 22:00 slower than typing it. A plain 24-hour field is faster once you have more than a few shifts, and invalid entries are flagged.

Break minutes come off the shift before anything else is calculated — before pay, and before the overtime threshold. That ordering matters more than it sounds: a 30-minute unpaid break on a 9-hour shift leaves 8.5 worked hours, so with an 8-hour threshold you are owed half an hour of overtime rather than a full hour. If you enter a break longer than the shift itself, the row is flagged instead of quietly producing a negative number.

Because on those days the whole shift is paid at that day’s multiplier, not just the hours past the threshold. That is how most rest-day and holiday rules are written — the day itself is the premium, so splitting it into normal and overtime hours would double-count it. If your contract does layer overtime on top of a rest-day rate, enter the shift as a normal day with the base rate adjusted to match.

Entering 09:00 to 09:00 gives zero, not twenty-four. There is no way for the tool to tell a 24-hour shift apart from a mistyped one, and guessing wrong in the generous direction would quietly inflate someone’s pay claim. Split a genuine round-the-clock shift into two rows.

None, deliberately. Overtime thresholds, rest-day premiums and holiday rates differ by country, by industry and very often by individual contract, and a rate that ships built in looks authoritative while being wrong for most of the people reading it. That is the same reason no public holiday list ships anywhere on this site. Every multiplier here is editable, and the ones you set are the ones used.

That is one of the better uses for it. Enter the shifts as they were actually worked, set the multipliers from your contract rather than from the payslip, and compare the total. Where the two disagree, the per-day breakdown shows which shift caused it — usually a break that was deducted twice, a rest day recorded as a normal day, or a shift crossing midnight that was counted on the wrong side of it.

Worked time is handled in whole minutes and only converted to decimal hours for the export, so nothing is rounded away in the middle of the calculation. If your employer rounds shift times to the nearest quarter hour, enter the rounded times — the tool will not apply a rounding rule it has not been told about.

Yes. Every field is quoted and internal quotes are doubled, so names with apostrophes and notes with commas do not shift the columns — which is the way a hand-built CSV usually fails, silently.