sum time in hh:mm:ss format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I have a column with time durations in hh:mm:ss format, how do I sum it
up? (ex 01:22:35 + 00:50:00 = 02:12:35)

thank you,

S.
 
=SUM(A1:A10) and format as [h]:mm:ss

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Back
Top