Tools / Time and payroll
Shift length calculator
Start, finish and unpaid break. Night shifts that end the next morning work too.
- Paid hours
- 8:00
- Decimal hours
- 8.00
- Shift including break
- 8:30
Do it in a spreadsheet
A2start timeB2end timeC2break minutes
How it works
MOD(end - start, 1) handles shifts that cross midnight: 6:30 minus 22:00 is negative, and MOD wraps it to 8.5 hours. Subtracting break minutes divided by 60 leaves the paid hours.