| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
overtime hours formula
Hello, I need to generate a formula to add 5 weeks of work x hourly rate but
the total of 5 weeks is larger than 40 hours, how can I take away only the 40 hours. here is the formula I have. =SUM('week-1:Week-5'!I12) this comes back with 48.25 hours and I need to get only 40 to multiply x regular time. and another one for the overtime. thank you in advance for your help. -- Louie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if then formula for total time ;overtime hours versus regular | Excel Worksheet Functions | |||
| regular and overtime hours | Excel Worksheet Functions | |||
| Overtime Hours | Excel Worksheet Functions | |||
| Calculating Overtime from Hours total | Excel Worksheet Functions | |||
| need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Threaded Mode
