How to get a sum of time?

[Davec43]

I'm trying to get a summary of the duration for ID's using summary statistics. Data type is text with no number format.

ID	Duration
ABCD	1:08:47
XYZ	0:09:23
XYZ	0:07:31
ABCD	0:04:30

When I try to do sum of the Duration Field, I get this error:

ERROR 000315 Field Formated_Total_Duration only supports statistic types MIN, MAX, MEAN, COUNT, FIRST, LAST, UNIQUE.

Is there a work around or another tool I should be using?

[KenBuja]

Can you convert that to a numeric time, such as minutes or seconds, and get the statistics for field instead?

[Davec43]

If I convert it into seconds in excel before importing the data over, it works.  Is there a way in arc to convert seconds to hh:mm:ss?

[KenBuja · Accepted solution]

You can use Arcade to do that. Take a look at this solution.

[DuncanHornby]

You don't say anything about how the time is stored, as you show it, it could be as a string, so summing a string makes no sense. You need to edit your question and add more detail, especially data format and what it is you are doing.