| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating timesheet with overtime
I'm trying to make a self calculating timesheet using formulas. So I can
enter in Mon-Sun amount of hours & they will automatically calculate "Reg" & "OT". I have the "Reg" but I'm trying to figure out how to make anything over 40 hours fall into the OT column. (I.E.: Mon-Sun 8 hours per day=56 hours total, I want 40 hours to fall under Regular time column & 16 hours to fall under the Overtime column). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help calculating overtime to date | Excel Worksheet Functions | |||
| help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
| overtime on timesheet | Excel Worksheet Functions | |||
| timesheet with running total of overtime | Excel Worksheet Functions | |||
| need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Threaded Mode
