topic Computation on Time in QlikView in QlikView https://community.qlik.com/t5/QlikView/Computation-on-Time-in-QlikView/m-p/995154#M967238 <HTML><HEAD></HEAD><BODY><P>Could anyone tell me how to find the difference of two time expression? I was trying to find subtract a time expression from another time expression, so that the resulting value is in minutes. Could anyone help me with this. The two time fields are as follows:</P><P></P><P>=Time(TIme#(Num(WORK_END_TIME,'0000'),'hhmm'),'hh:mm') </P><P>=Time(TIme#(Num(WORK_START_TIME,'0000'),'hhmm'),'hh:mm')</P><P></P><P>How do I get the time difference\ minutes from these time strings.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT 2020-11-20T18:02:30Z Computation on Time in QlikView https://community.qlik.com/t5/QlikView/Computation-on-Time-in-QlikView/m-p/995154#M967238 <HTML><HEAD></HEAD><BODY><P>Could anyone tell me how to find the difference of two time expression? I was trying to find subtract a time expression from another time expression, so that the resulting value is in minutes. Could anyone help me with this. The two time fields are as follows:</P><P></P><P>=Time(TIme#(Num(WORK_END_TIME,'0000'),'hhmm'),'hh:mm') </P><P>=Time(TIme#(Num(WORK_START_TIME,'0000'),'hhmm'),'hh:mm')</P><P></P><P>How do I get the time difference\ minutes from these time strings.</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Computation-on-Time-in-QlikView/m-p/995154#M967238 2020-11-20T18:02:30Z Re: Computation on Time in QlikView https://community.qlik.com/t5/QlikView/Computation-on-Time-in-QlikView/m-p/995155#M967239 <HTML><HEAD></HEAD><BODY><P>Subtract them and use the interval function to show the result in minutes: <STRONG>Interval</STRONG>( <EM>Time1 - Time2</EM>, <STRONG>'m'</STRONG>)</P></BODY></HTML> Mon, 05 Oct 2015 12:28:18 GMT https://community.qlik.com/t5/QlikView/Computation-on-Time-in-QlikView/m-p/995155#M967239 Gysbert_Wassenaar 2015-10-05T12:28:18Z