Working hours Excel

  Tulips 18:07 04 Mar 2010

If Fred starts work at 6:30 and finishes at 15:30 what formula in excel do I use to show how many hours he has worked in this time period please?
I have office 2007.

  VoG II 18:27 04 Mar 2010

With 06:30 in A1 and 15:30 in B1 use


and format the result cell as Time.

If you want the result as decimal time then


and format the result cell as Number.

  Tulips 21:13 04 Mar 2010

Thanks VoG

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy S9 review

ManvsMachine and other artists put Apple's iMac Pro to the test using powerful rendering tools

What to expect at Apple's 27 March education event

Comment filmer l’écran d’un iPhone ?