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



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


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…