In Excel how do I use the Time function (think this is the one) to calculate the overall average time in hours when presented with two lengthy columns of Time data?e.g column B1= 10:00am is Start Time and C1= 10:42am is Finish Time, then B2= 10:45am and C2= 11:30am etc etc...Advice greatly appreciated.Durko
In D1 enter the formula=C1-B1and copy the formula down.To calculate the average use=AVERAGE(D1:D100)Substitute the last used cell in D for D100 in the above.
VOGAdvice much appreciated.
This thread is now locked and can not be replied to.
iMac Pro review
Illustrator Charles Williams on how to create magazines and book covers
Les meilleures prises CPL (2018)
© Copyright 2018 IDG UK. All Rights Reserved.