how do i make overtime in my payroll sheet calculate after 42.5 h.
In the template for payroll, where it calculates regular time and overtime,
the formula reads =MIN(E17,Overtime/12). When I change the #12 someitmes it
changes the overtime. I want it to calculate overtime as 4 anything over
42.5 hours. Can you tell me how to do this? Thankyou
|