I need a formula that will calculate the hours on shift. eg. start at 10.30pm finish at 2am total hours=?
I have done it and will now look for it for you.
With start time in C2 and finish time in D2, enter the following formula in E2=IF(D2<C2,TEXT(1+D2-C2,"[hh]:mm"),TEXT(D2-C2,"[hh]:mm"))Notes:C2 and D2 have to be formatted as TimeThis will work for shifts up to 24 hours.
I have written a "Time Sheet" in Excel for the department I used to work in (retired now). if you would like a copy to try for yourself email me and I will send it to youPete
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.