Let's say A1 =21:00, B1 =09:00
C1 =(B1-A1)+(A1B1)


"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!