I wouldn't recommend adding 24 days, Cin. (It will give an answer of 564
hours instead of 12).
1 day would make more sense.
--
David Biddulph

"Cin" wrote in message
...
=IF(E11E10, E11-E10,(E11+24)-E10)

Where E11 is the finish time and E10 is the start time.

"Kelsey" wrote:

Here's the Excel time sheet I've been working on, and here's the problem:

This is an example of an employee who works the overnight shift:
When we enter 21:00 as an 'In' time, and 09:00 as the 'Out' time, the
total
hrs do not calculate properly.

If I convert 09:00 to 33:00 (24:00 + 09:00) it works properly, but this
is
not an acceptable solution since I want to turn this worksheet over to
the
managers to enter employee's times, and they'll not 'get' it.

Just FYI, this is for an assisted living home that has 24 hr staffing.
They
have been using military time, and it confuses everyone when it comes to
totaling the hours, so we want Excel to do the calculating.

Do you think you can fix this mess for us?? You'll be my hero!