https://community.esri.com/t5/arcgis-survey123-questions/date-time-format/m-p/1255129#M47294 <P><SPAN class="">Hello, I am calculating the duration hours with the following formula: </SPAN></P><P><SPAN class="">int((${PGDHEnd} - ${PGDHStart}) div(1000*60)) div(60) </SPAN></P><P><SPAN class="">although it can give me a result like the one in the photo I wanted you to set an example 7:30 pm - 6:00 pm = 1:30 am just not and it is giving me the value that is in the photo 1.5 hours of duration thank you very much</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarceloCatalo_0-1675537489558.png" style="width: 746px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/62097i1EFAD02FF09DBC48/image-dimensions/746x97?v=v2" width="746" height="97" role="button" title="MarceloCatalo_0-1675537489558.png" alt="MarceloCatalo_0-1675537489558.png" /></span></P><P>&nbsp;</P> Sat, 04 Feb 2023 19:05:12 GMT MarceloCatalão 2023-02-04T19:05:12Z https://community.esri.com/t5/arcgis-survey123-questions/date-time-format/m-p/1255129#M47294 <P><SPAN class="">Hello, I am calculating the duration hours with the following formula: </SPAN></P><P><SPAN class="">int((${PGDHEnd} - ${PGDHStart}) div(1000*60)) div(60) </SPAN></P><P><SPAN class="">although it can give me a result like the one in the photo I wanted you to set an example 7:30 pm - 6:00 pm = 1:30 am just not and it is giving me the value that is in the photo 1.5 hours of duration thank you very much</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarceloCatalo_0-1675537489558.png" style="width: 746px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/62097i1EFAD02FF09DBC48/image-dimensions/746x97?v=v2" width="746" height="97" role="button" title="MarceloCatalo_0-1675537489558.png" alt="MarceloCatalo_0-1675537489558.png" /></span></P><P>&nbsp;</P> Sat, 04 Feb 2023 19:05:12 GMT https://community.esri.com/t5/arcgis-survey123-questions/date-time-format/m-p/1255129#M47294 MarceloCatalão 2023-02-04T19:05:12Z https://community.esri.com/t5/arcgis-survey123-questions/date-time-format/m-p/1255159#M47297 <P>The time duration is correct as per your screenshot. It should be 1.5 hours, rather than 1:30 AM. 1:30 AM is a time, not time interval.</P><P>Could you share more information on why you want the difference value as time rather than time difference?</P> Sun, 05 Feb 2023 13:14:57 GMT https://community.esri.com/t5/arcgis-survey123-questions/date-time-format/m-p/1255159#M47297 JayantaPoddar 2023-02-05T13:14:57Z