excel formula for calculating hours

  User-F5267F1B-9923-4FB3-B12E49C9062E4994 17:42 01 Mar 2003
Locked

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 2003

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

  VoG™ 18:34 01 Mar 2003

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 2003

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.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?