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
With 06:30 in A1 and 15:30 in B1 use=B1-A1and format the result cell as Time.If you want the result as decimal time then=(B1-A1)*24and format the result cell as Number.
This thread is now locked and can not be replied to.
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 ?
© Copyright 2018 IDG UK. All Rights Reserved.