topic How to get a sum of time? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268535#M66737 <P>I'm trying to get a summary of the duration for ID's using summary statistics. Data type is text with no number format.</P><TABLE width="151"><TBODY><TR><TD width="70">ID</TD><TD width="81">Duration</TD></TR><TR><TD>ABCD</TD><TD>1:08:47</TD></TR><TR><TD>XYZ</TD><TD>0:09:23</TD></TR><TR><TD>XYZ</TD><TD>0:07:31</TD></TR><TR><TD>ABCD</TD><TD>0:04:30</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When I try to do sum of the Duration Field, I get this error:</P><P>ERROR 000315 Field Formated_Total_Duration only supports statistic types MIN, MAX, MEAN, COUNT, FIRST, LAST, UNIQUE.</P><P>Is there a work around or another tool I should be using?</P> Thu, 16 Mar 2023 16:28:14 GMT Davec43 2023-03-16T16:28:14Z How to get a sum of time? https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268535#M66737 <P>I'm trying to get a summary of the duration for ID's using summary statistics. Data type is text with no number format.</P><TABLE width="151"><TBODY><TR><TD width="70">ID</TD><TD width="81">Duration</TD></TR><TR><TD>ABCD</TD><TD>1:08:47</TD></TR><TR><TD>XYZ</TD><TD>0:09:23</TD></TR><TR><TD>XYZ</TD><TD>0:07:31</TD></TR><TR><TD>ABCD</TD><TD>0:04:30</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>When I try to do sum of the Duration Field, I get this error:</P><P>ERROR 000315 Field Formated_Total_Duration only supports statistic types MIN, MAX, MEAN, COUNT, FIRST, LAST, UNIQUE.</P><P>Is there a work around or another tool I should be using?</P> Thu, 16 Mar 2023 16:28:14 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268535#M66737 Davec43 2023-03-16T16:28:14Z Re: How to get a sum of time? https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268540#M66738 <P>Can you convert that to a numeric time, such as minutes or seconds, and get the statistics for field instead?</P> Thu, 16 Mar 2023 15:30:08 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268540#M66738 KenBuja 2023-03-16T15:30:08Z Re: How to get a sum of time? https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268559#M66740 <P>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.</P> Thu, 16 Mar 2023 16:19:31 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268559#M66740 DuncanHornby 2023-03-16T16:19:31Z Re: How to get a sum of time? https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268565#M66741 <P>If I convert it into seconds in excel before importing the data over, it works.&nbsp; Is there a way in arc to convert seconds to hh:mm:ss?</P> Thu, 16 Mar 2023 16:24:49 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268565#M66741 Davec43 2023-03-16T16:24:49Z Re: How to get a sum of time? https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268593#M66748 <P>You can use Arcade to do that. Take a look at <A href="https://community.esri.com/t5/developers-questions/how-do-i-convert-seconds-to-minutes-hours-or-days/td-p/186038" target="_self">this solution</A>.</P> Thu, 16 Mar 2023 16:56:10 GMT https://community.esri.com/t5/arcgis-pro-questions/how-to-get-a-sum-of-time/m-p/1268593#M66748 KenBuja 2023-03-16T16:56:10Z