Excel hour formula

  VNAM75 10:35 13 Jun 2007
Locked

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?

  johnnyrocker 10:49 13 Jun 2007

would not the sum equation cover this if i understand you correctly?


johnny.

  VoG II 10:51 13 Jun 2007

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]

  VNAM75 11:05 13 Jun 2007

Thanks! I was making it more complicated than necessary

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

Elsewhere on IDG sites

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