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

Intel Coffee Lake release date and specifications

12 Amazing British Craft Beer Label Designs

watchOS 4 review

Les meilleurs navigateurs internet 2017