sum time in hh:mm:ss format

S

steven

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.
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Top