| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula used to calculate daily employment hours ...
Excel version 2003...I need to calculate overtime hours....how do you
differentiate between AM PM....how do you caluculate when hours run from one day to the next ex. 11:00pm - 2:00Am the following day |
|
#2
|
|||
|
|||
|
Another option may be to enter both the date and time.
DarDarren wrote: Excel version 2003...I need to calculate overtime hours....how do you differentiate between AM PM....how do you caluculate when hours run from one day to the next ex. 11:00pm - 2:00Am the following day -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| Formula displays does not calculate | Excel Discussion (Misc queries) | |||
Linear Mode
