sum time in hh:mm:ss format

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

Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding time durations 2
dd:hh:mm:ss 2
time questions (roundup & convert hh to mm 1
Shortcut for current Time in hh:mm:ss 2
calc time value 3
Sum of minutes and seconds times price? 2
Import into excel (Time) 3
years-months-days-hours 5

Top