https://community.dynatrace.com/t5/DQL/Calculate-Duration-from-Specific-Fields-Using-DQL/m-p/282100#M2365 <P>Calculate Duration from fields (StartTime and EndTime) and display the start date<BR /><BR /></P> <TABLE width="446"> <TBODY> <TR> <TD width="64">Task</TD> <TD width="84">StartDate</TD> <TD width="99">EndDate</TD> <TD width="87">StartTime</TD> <TD width="112">EndTime</TD> </TR> <TR> <TD>A</TD> <TD>7/21/2025</TD> <TD>7/21/2025</TD> <TD>23:00:01</TD> <TD>23:09:24</TD> </TR> <TR> <TD>B</TD> <TD>7/22/2025</TD> <TD>7/22/2025</TD> <TD>00:59:53</TD> <TD>01:24:01</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Need to calculate duration from&nbsp;23:00:01 to&nbsp;01:24:01 and display date as&nbsp;7/21/2025 and duration.&nbsp;</P> Wed, 17 Dec 2025 13:44:53 GMT goutham_a 2025-12-17T13:44:53Z https://community.dynatrace.com/t5/DQL/Calculate-Duration-from-Specific-Fields-Using-DQL/m-p/282100#M2365 <P>Calculate Duration from fields (StartTime and EndTime) and display the start date<BR /><BR /></P> <TABLE width="446"> <TBODY> <TR> <TD width="64">Task</TD> <TD width="84">StartDate</TD> <TD width="99">EndDate</TD> <TD width="87">StartTime</TD> <TD width="112">EndTime</TD> </TR> <TR> <TD>A</TD> <TD>7/21/2025</TD> <TD>7/21/2025</TD> <TD>23:00:01</TD> <TD>23:09:24</TD> </TR> <TR> <TD>B</TD> <TD>7/22/2025</TD> <TD>7/22/2025</TD> <TD>00:59:53</TD> <TD>01:24:01</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Need to calculate duration from&nbsp;23:00:01 to&nbsp;01:24:01 and display date as&nbsp;7/21/2025 and duration.&nbsp;</P> Wed, 17 Dec 2025 13:44:53 GMT https://community.dynatrace.com/t5/DQL/Calculate-Duration-from-Specific-Fields-Using-DQL/m-p/282100#M2365 goutham_a 2025-12-17T13:44:53Z https://community.dynatrace.com/t5/DQL/Calculate-Duration-from-Specific-Fields-Using-DQL/m-p/282108#M2366 <P><a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/86038">@goutham_a</a>&nbsp;You can try similar to below as an example&nbsp;</P><P><A href="https://docs.dynatrace.com/docs/shortlink/dql-data-types#duration" target="_blank">https://docs.dynatrace.com/docs/shortlink/dql-data-types#duration</A></P><P>&nbsp;</P><LI-CODE lang="markup"> | fieldsAdd duration = (timeframe[end]) - (timeframe[start]) | fields duration, timeframe[start]</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="p_devulapalli_0-1753236133235.png" style="width: 239px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/29149iCC388F55ADF7D008/image-dimensions/239x162?v=v2" width="239" height="162" role="button" title="p_devulapalli_0-1753236133235.png" alt="p_devulapalli_0-1753236133235.png" /></span></P><P>&nbsp;</P> Wed, 23 Jul 2025 02:04:09 GMT https://community.dynatrace.com/t5/DQL/Calculate-Duration-from-Specific-Fields-Using-DQL/m-p/282108#M2366 p_devulapalli 2025-07-23T02:04:09Z