ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sum time in hh:mm:ss format (https://www.excelbanter.com/excel-discussion-misc-queries/89100-sum-time-hh-mm-ss-format.html)

steven

sum time in hh:mm:ss format
 
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.

Bob Phillips

sum time in hh:mm:ss format
 
=SUM(A1:A10) and format as [h]:mm:ss

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"steven" wrote in message
...
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.





All times are GMT +1. The time now is 08:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com