| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Overtime Calculations
I want to add a column of numbers, with a "Regular Time" box and "Overtime
Box". I need the formula to add the column. If the total is over 40 hours, then I need it to put 40 in the Regular box and the difference between the actual total and 40 in the Overtime box. If the total is below 40, then put the actual number in the Regular box. Thanks in advance for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) | |||
| Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
| Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
| Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions | |||
| IF or SUMIF help for Overtime Formula | Excel Worksheet Functions | |||
Threaded Mode
