I have a range of cells (A1:A5) with time duration values in them in hh:mm:ss format. Can anyone provide a formula to calculate the total number of hours in that range?
would not the sum equation cover this if i understand you correctly?johnny.
Just sum them as johnnyrocker said. You will need to format the result cell as Time or if the total could exceed 24 hours then use a custom format[h]
Thanks! I was making it more complicated than necessary
This thread is now locked and can not be replied to.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.