Formula
The break is converted from minutes to hours:
Paid hours = day hours added − unpaid break / 60
The result does not go below zero. Overtime hours compare a total with a schedule instead of listing days.
Assumptions
- The five fields are the days you want to total.
- The break is unpaid and applies once.
Worked example
Five 8-hour days with a 30-minute unpaid break leave 39.5 paid hours.
Input definitions
- Unpaid break
- Minutes to remove from the total, from 0 to 240.
Limitations
This is five days and one break, not a full payroll period.
Questions
What if a day was off?
Enter zero for that day.
Can the break erase the week?
The paid hours stop at zero.