Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating time
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating time
One way:
A1: 9:00 AM A2: 5:00 PM A3: =A2-A1 === 8:00 when A3 is formatted as h:mm If you have shifts that span midnight: A3: =MOD(A2-A1,1) Since XL stores times as fractional days. In article , jgullett wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating time
Easiest is to use 24 hr clock 17:00-9:00 -- Don Guillett SalesAid Software "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? |
#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? |
Reply |
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 |