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.

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