Working hours Excel

  Tulips 18:07 04 Mar 10
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 10

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 10

Thanks VoG

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

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…