Working hours Excel

  Tulips 18:07 04 Mar 2010
Locked

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.
Thanks

  VoG II 18:27 04 Mar 2010

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

=B1-A1

and format the result cell as Time.

If you want the result as decimal time then

=(B1-A1)*24

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 ?