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

Free, from Producfy

Get the next guide before you need it

One email when a new guide or tool goes up: working formulas, queries and scripts for spreadsheets, SQL and the CRM and billing exports that end up in them. At most one a week.

Esc