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

What is ransomware and how do I protect my PC from Petya?

Microsoft Surface Studio – the artist's hands-on review

Original iPhone review

Comment mettre à jour Kodi ?