excel formula for calculating hours

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

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



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


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 ?