nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Finde mehr Beiträge mit dem Tag

Analysis

Content Management

Desktop

Accepted answers

kenbuja

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

All comments

kenbuja

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

Hornbydd

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.

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

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

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.