https://community.qlik.com/t5/Talend-Studio/Get-Total-Time-from-start-DateTime-and-End-DateTime/m-p/2366329#M129831 <P>Input: data type is Date</P><P>2023-12-09T07:43:03.792Z | 2023-12-09T13:51:02.552Z </P><P><span class="lia-inline-image-display-wrapper" image-alt="069U1000001ItfIIAS.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157858i720E740E0A5C9620/image-size/large?v=v2&amp;px=999" role="button" title="069U1000001ItfIIAS.png" alt="069U1000001ItfIIAS.png" /></span>&nbsp;</P><P>Output:</P><P>hh:mm:ss format</P><P><span class="lia-inline-image-display-wrapper" image-alt="069U1000001JDgwIAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150763i71E137301CE07D32/image-size/large?v=v2&amp;px=999" role="button" title="069U1000001JDgwIAG.png" alt="069U1000001JDgwIAG.png" /></span></P> Fri, 15 Nov 2024 21:09:45 GMT Sbxr80 2024-11-15T21:09:45Z https://community.qlik.com/t5/Talend-Studio/Get-Total-Time-from-start-DateTime-and-End-DateTime/m-p/2366329#M129831 <P>Input: data type is Date</P><P>2023-12-09T07:43:03.792Z | 2023-12-09T13:51:02.552Z </P><P><span class="lia-inline-image-display-wrapper" image-alt="069U1000001ItfIIAS.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157858i720E740E0A5C9620/image-size/large?v=v2&amp;px=999" role="button" title="069U1000001ItfIIAS.png" alt="069U1000001ItfIIAS.png" /></span>&nbsp;</P><P>Output:</P><P>hh:mm:ss format</P><P><span class="lia-inline-image-display-wrapper" image-alt="069U1000001JDgwIAG.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150763i71E137301CE07D32/image-size/large?v=v2&amp;px=999" role="button" title="069U1000001JDgwIAG.png" alt="069U1000001JDgwIAG.png" /></span></P> Fri, 15 Nov 2024 21:09:45 GMT https://community.qlik.com/t5/Talend-Studio/Get-Total-Time-from-start-DateTime-and-End-DateTime/m-p/2366329#M129831 Sbxr80 2024-11-15T21:09:45Z https://community.qlik.com/t5/Talend-Studio/Get-Total-Time-from-start-DateTime-and-End-DateTime/m-p/2366330#M129832 <P>Hi </P><P>I'm afraid there is no direct function to get the result you want, if you have some Java knowledge, you can have a try to hard code on tJavaRow component, use the built-in function T<A href="https://help.talend.com/r/en-US/8.0/studio-user-guide/retrieving-part-of-date" alt="https://help.talend.com/r/en-US/8.0/studio-user-guide/retrieving-part-of-date" target="_blank">alendDate.getPartOfDate() to get each part of time, </A>then do the subtraction for each part of time and build the output string. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P><P>​</P> Tue, 26 Dec 2023 07:20:28 GMT https://community.qlik.com/t5/Talend-Studio/Get-Total-Time-from-start-DateTime-and-End-DateTime/m-p/2366330#M129832 Anonymous 2023-12-26T07:20:28Z