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

iPhone X review

Political cartoons in 2017: Chris Riddell, Rebecca Hendin and Dave Brown on what it’s like to…

The best iPhone for 2017

Tennis : comment regarder la finale de la Coupe Davis 2017 ?