Hours calculator

How it works

Each row counts from the start to the end time and subtracts the break. An end time earlier than the start counts as a night shift that ends the next day, so 22:00 to 06:00 is 8 hours. Decimal hours are rounded to two places, as most payroll systems expect: 7 hours 45 minutes is 7.75. Clock changes on the night of a shift are not taken into account.

For overtime, enter the weekly hours after which overtime starts; hours above it are counted at the multiplier you enter (1.5 if you leave it empty). Leave the threshold empty for no overtime. Overtime rules differ by country, state and contract, so treat the split and pay as a worksheet and check them against your own rules. The CSV opens in any spreadsheet.