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?

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?

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?

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?