excel formula for calculating hours

I need a formula that will calculate the hours on shift. eg. start at 10.30pm finish at 2am total hours=?

  howard60 17:47 01 Mar 03

I have done it and will now look for it for you.

  VoG™ 18:34 01 Mar 03

With start time in C2 and finish time in D2, enter the following formula in E2

=IF(D2<C2,TEXT(1+D2-C2,"[hh]:mm"),TEXT(D2-C2,"[hh]:mm"))

Notes:

C2 and D2 have to be formatted as Time

This will work for shifts up to 24 hours.

  pj123 10:55 02 Mar 03

I have written a "Time Sheet" in Excel for the department I used to work in (retired now). if you would like a copy to try for yourself email me and I will send it to you

Pete

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…