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.

Huawei P10 review

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

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now