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

=MOD(B2-A2,1)*24-C2/60
  • A2 start time
  • B2 end time
  • C2 break 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.

More time and payroll tools

Esc