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

Sea of Thieves Review

Dell Canvas review: the cheap Wacom Cintiq alternative

How to use iMovie for Mac, tips and more

Comment filmer l’écran d’un iPhone ?