https://community.qlik.com/t5/QlikView/How-to-Calculate-Duration-from-Two-Times/m-p/1773214#M718065 <P>Hi,</P><P>thanks for quick reply,</P><P>Unabel to run first code in PL/SQL Developer Error Message Emerge (ORA-00936 Missing Expression)</P> Mon, 11 Jan 2021 06:58:34 GMT nuwanhwb87 2021-01-11T06:58:34Z https://community.qlik.com/t5/QlikView/How-to-Calculate-Duration-from-Two-Times/m-p/1773162#M718063 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="03.PNG" style="width: 466px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46714i8CD38571A80D0219/image-size/large?v=v2&amp;px=999" role="button" title="03.PNG" alt="03.PNG" /></span></P><P>Hi,</P><P>I have Above table with IN Time and Out Time.</P><P>Need to calculate total Duration</P><P>Out Time - In Time</P><P>Specially How to Extract the time from Above Date Format</P> Sat, 16 Nov 2024 17:37:57 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Duration-from-Two-Times/m-p/1773162#M718063 nuwanhwb87 2024-11-16T17:37:57Z https://community.qlik.com/t5/QlikView/How-to-Calculate-Duration-from-Two-Times/m-p/1773163#M718064 <P>Perhaps this</P><P><STRONG>Date(Date#(IN_TIME, 'DD/MM/YYYY HH:MM:SS TT')-Date#(OUT_TIME, 'DD/MM/YYYY HH:MM:SS TT'), 'HH:MM:SS')</STRONG></P><P><STRONG>Or</STRONG></P><P><STRONG>Interval(Date#(IN_TIME, 'DD/MM/YYYY HH:MM:SS TT')-Date#(OUT_TIME, 'DD/MM/YYYY HH:MM:SS TT'), 'HH')</STRONG></P> Sun, 10 Jan 2021 15:59:23 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Duration-from-Two-Times/m-p/1773163#M718064 Anil_Babu_Samineni 2021-01-10T15:59:23Z https://community.qlik.com/t5/QlikView/How-to-Calculate-Duration-from-Two-Times/m-p/1773214#M718065 <P>Hi,</P><P>thanks for quick reply,</P><P>Unabel to run first code in PL/SQL Developer Error Message Emerge (ORA-00936 Missing Expression)</P> Mon, 11 Jan 2021 06:58:34 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Duration-from-Two-Times/m-p/1773214#M718065 nuwanhwb87 2021-01-11T06:58:34Z