ExcelBanter - how do i make overtime in my payroll sheet calculate after 42.5 h.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i make overtime in my payroll sheet calculate after 42.5 h. (https://www.excelbanter.com/excel-worksheet-functions/20218-how-do-i-make-overtime-my-payroll-sheet-calculate-after-42-5-h.html)

Kaye

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

All times are GMT +1. The time now is 09:05 AM.