https://community.qlik.com/t5/QlikView/how-to-calculate-average-time-between-two-timestamp-fields/m-p/405732#M150978 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your quick responce. I have used Interval(Interval()) instand of interval(interval#()) and it is working fine.</P><P></P><P> Interval(Interval(date#(ack_dt, 'MM/DD/YYYY hh:mm:ss')- date#(send_dt,'MM/DD/YYYY hh:mm:ss'), 'mm:ss'),'ss') as SEND_DT_2_ACK_DT_HR,</P></BODY></HTML> Sat, 27 Apr 2013 02:35:54 GMT 2013-04-27T02:35:54Z https://community.qlik.com/t5/QlikView/how-to-calculate-average-time-between-two-timestamp-fields/m-p/405730#M150976 <HTML><HEAD></HEAD><BODY><P>im trying to find the best way to calculate the average time taken between two timestamp fileds. i was trying to achive this during load time but i dont know how to out put a hole number ie. instead of 1 min 17 sec, i want to convert into eaither every thing in min or sec. I mean in this case i want to show 77 sec instad of 1:17sec. So i can calculate the aveage number at chart level. </P><P></P><P> look at my qvd load script and let me know how to convert SEND_DT_2_ACK_DT_HR eaither in to mintues or seconds. </P><P></P><P>Please adive is there any ulternative method available to calculate the agerage time taken between dates.</P><P></P><P>Thank you for your help. </P></BODY></HTML> Fri, 26 Apr 2013 20:43:15 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-average-time-between-two-timestamp-fields/m-p/405730#M150976 2013-04-26T20:43:15Z https://community.qlik.com/t5/QlikView/how-to-calculate-average-time-between-two-timestamp-fields/m-p/405731#M150977 <HTML><HEAD></HEAD><BODY><P>You may try using the Interval() function.</P><P>For example </P><P>Interval(Interval#('1:17','mm:ss'),'ss') </P><P>returns 77</P></BODY></HTML> Sat, 27 Apr 2013 00:04:10 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-average-time-between-two-timestamp-fields/m-p/405731#M150977 nagaiank 2013-04-27T00:04:10Z https://community.qlik.com/t5/QlikView/how-to-calculate-average-time-between-two-timestamp-fields/m-p/405732#M150978 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your quick responce. I have used Interval(Interval()) instand of interval(interval#()) and it is working fine.</P><P></P><P> Interval(Interval(date#(ack_dt, 'MM/DD/YYYY hh:mm:ss')- date#(send_dt,'MM/DD/YYYY hh:mm:ss'), 'mm:ss'),'ss') as SEND_DT_2_ACK_DT_HR,</P></BODY></HTML> Sat, 27 Apr 2013 02:35:54 GMT https://community.qlik.com/t5/QlikView/how-to-calculate-average-time-between-two-timestamp-fields/m-p/405732#M150978 2013-04-27T02:35:54Z