| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating time
Try this:
A1 = 9:00 AM B1 = 5:00 PM For a result in TIME format: format the cell as h:mm =IF(COUNT(A1:B1)<2,"",B1-A1+(B1<A1)) Result = 8:00 For a result in DECIMAL format: format the cell as GENERAL =IF(COUNT(A1:B1)<2,"",(B1-A1+(B1<A1))*24) Result = 8 Biff "jgullett" wrote in message ... I am needing to calculate time in Excel 2003. Say someone comes in to work at 9 AM and works until 5PM, how can I create a formula to automatically count the total time worked? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time increments from dates during working hours | Excel Worksheet Functions | |||
| calculating time | Excel Discussion (Misc queries) | |||
| help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
| Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Threaded Mode
