Enter a start and an end time to get the duration in hours and minutes, in decimal hours for payroll, and with breaks deducted. Times that cross midnight are handled properly: 22:00 to 06:00 is eight hours, not minus sixteen. The second tab totals a whole week and splits out overtime.
Subtracting 22:00 from 06:00 gives minus sixteen hours, which is why night shifts break so many spreadsheets. The right reading is: count to midnight, then add what comes after — two hours plus six, so eight. An end time earlier than the start is treated here as the next day.
Payroll works in decimal hours: 8 hours 15 minutes is 8.25, not 8.15. Multiplying 8.15 by an hourly rate quietly underpays by six minutes per entry. Across a workforce and a year that is a real amount of money, and it is one of the most common payroll errors there is.
The conversion is minutes divided by 60: 15 minutes is 0.25, 20 minutes is 0.33, 45 minutes is 0.75. Only 0, 15, 30 and 45 land on clean decimals, which is why the others get mistyped.
Unpaid ones. Whether a break is paid depends on jurisdiction and contract — in many places short breaks under about twenty minutes are paid while a longer meal break is not. Enter only the unpaid minutes, or the total will be short.
Count to midnight, then add the time after it. From 22:00 to 06:00 is two hours plus six, so eight. Subtracting the raw numbers gives minus sixteen, which is the mistake spreadsheets make when the end time is not marked as the next day. This calculator reads an earlier end time as crossing midnight.
Time in hours with the minutes expressed as a fraction rather than as minutes: 8 hours 15 minutes is 8.25, not 8.15. Multiplying 8.15 by an hourly rate underpays by six minutes an entry, which adds up quickly across a workforce.
Unpaid breaks yes, paid breaks no, and which is which depends on your jurisdiction and contract. In many places breaks under about 20 minutes are paid and longer meal breaks are not. Enter only the unpaid minutes.
Steuervergleich Kanton Zürich — Gemeindesteuern vergleichen (Deutsch)