Calculating hours worked beyond midnight

**Boville** · 12-25-2012, 11:37 AM

Hello again

I cant figure out how to calculate a shift that would go beyond midnight....for example a start time of 21:00 end time of 07:00.

Thanks,

Merry Xmas!

**dogberry** · 12-25-2012, 12:05 PM

Hi

You need to format your cellls in [h]:mm format you have hh:mm at the moment the square brackets are important.

Chris

**Boville** · 12-25-2012, 12:10 PM

They are already formated as such however it still wont work

**jeffreybrown** · 12-25-2012, 12:14 PM

How about...

=((C2+(C2<B2))-B2)

C2 = End Time
B2 = Start Time

**Boville** · 12-25-2012, 12:19 PM

I dont know how you math wizzards do it but I wish I had payed attention in High School.....Thanks Jeffery it worked!

Thanks Dogberry for your contribution as well.