I have a table that I need to find a total duration of attributes. NameDurationABCDEFG00:00:11ABCDEFG00:10:00ABCDEFG00:01:00 How do I calculate the Duration and put the total in a new field?

You're confusing the fields in the tool. Field Name (existing or new) = the new field you want to create (SUM_total_seconds) you need to use !Duration! in the script. at the moment you're trying to use split on a value which doesn't exist and also the wrong field type, and then populate a float into a string field which is all wrong. Best to just create a new field of type float, then use field calculator as it will be simpler.

I get: ERROR 000539: Traceback (most recent call last): File " ", line 1, in AttributeError: 'float' object has no attribute 'split'

Change your expression type to Python

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 duration of similar attributes?

Davec43

I have a table that I need to find a total duration of attributes.

Name	Duration
ABCDEFG	00:00:11
ABCDEFG	00:10:00
ABCDEFG	00:01:00

How do I calculate the Duration and put the total in a new field?

Vind meer berichten getagd met

Analysis

Desktop

Accepted answers

All comments

Robert_LeClair

Dave - I know this tool may not be what you're looking for, but Summary Statistics (Analysis), would provide a sum of the Duration values BUT it creates a new output table in your geodatabase vs. in the existing feature class table. You could use a Join of the output table to the feature class table though if that would suffice.

Davec43

That looks like the path to go down but I keep getting this error when I try to use Sum for statistic type.

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

DavidPike

Is duration a string? You'd be best creating a new 'seconds' field and doing a field calculate using python.

Not tested it at all but something along the lines of : (I know it would be less verbose as a code block)

(float(duration.split(":")[0]) * 3600) + (float(duration.split(":")[1]) * 60) +(float(duration.split(":")[2]))

Davec43

Something along the lines of this? Duration is the new field and SUM_Total_Seconds is the seconds field

Sum_Total_Seconds = [f.type for f in arcpy.ListFields(SUM_Total_Seconds) if f.name == sDep][0]
arcpy.management.CalculateField("mStatistics", "Duration", "!Duration!", "PYTHON3", '(float(SUM_Total_Seconds.split(":")[0]) * 3600) + (float(SUM_Total_Seconds.split(":")[1]) * 60) +(float(SUM_Total_Seconds.split(":")[2]))', "TEXT", "NO_ENFORCE_DOMAINS")

Davec43

I keep getting an error when I try this:

ERROR 002717: Invalid Arcade expression, Arcade error: Close parenthesis expected, Script line: 1

But I don't see where you'd close the parenthesis?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Alle Gemeenschappen
Recente Berichten
Gevolgde Inhoud
Community Hulp

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