| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| How do I make excel startup in a specific sheet? | Excel Worksheet Functions | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
