Hi!

See which method you might prefer:

A1 = 10:00 AM
B1 = 5:00 PM
C1 = formula:

=(B1-A1+(B1<A1))*24

OR......

A1 = 10:00 AM - 5:00 PM
B1 = formula:

=((SUBSTITUTE(A1,LEFT(A1,FIND("-",A1)+1),"")*1-SUBSTITUTE(A1,RIGHT(A1,FIND("-",A1)-1),"")*1)+(SUBSTITUTE(A1,LEFT(A1,FIND("-",A1)+1),"")*1<SUBSTITUTE(A1,RIGHT(A1,FIND("-",A1)-1),"")*1))*24

Seems like a no brainer to me! <g

Biff

"James Fullmer" <James wrote in message
...
I am trying to create a schedule that calculates hours worked in a day. I
have several restrictions in space, so would like to have one cell that
shows
start and end time, and a second cell that shows hours worked.

For instance
A1 10:00 AM - 5:00 PM
B1 8

I am basically looking for the formula to put in B1