# How to sum duration times in (hh:mm:ss) format

Hello again, Experts:

Call-Summary-by-Extension-111-EE-11-24-1I need a formula that will total duration times in hh:mm:ss format.  See sample attached.  Hoping you can help.

Thanks,
Gary - cincinnati
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
I can't quickly think of a way to sum the column you specify (it is text), but the "duration in seconds" colums can be easily summed and formatted as hh:mm:ss.
This calculates the total duration for your example worksheet as 102 hours, 29 minutes and 46 seconds
1. Sum and convert to seconds to  days (in Excel, 1 day = 1.0)
=SUM(H2:H226)/60/60/24

2. Then choose custom format for the result cell. This format displays values that exceed one day in hh:mm:ss.
[h]:mm:ss

Edit: On second thoughts, you CAN sum the column you asked for by using an array formula:
{=SUM(VALUE(G2:G226))}
and then formatting as described above [h]:mm:ss

On the Mac I'm sitting at now I have to use Command+Shift+Enter to create the array formula (you can't manually type the curly braces). On Windows it is CTRL+SHIFT+ENTER.

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Solutions ConsultantCommented:
First format the cells to be summed to the following

[h]:mm:ss

Then you can just use =SUM(H2:H226).

Ensure that the result cell is also formatted as [h]:mm:ss
Author Commented: