topic Re: Average Time in QlikView https://community.qlik.com/t5/QlikView/Average-Time/m-p/678909#M1060485 <HTML><HEAD></HEAD><BODY><P>Timestamp(Numavg(timestamp1, previous(timestamp1)))</P><P>?</P><P></P><P>hope this helps</P><P>regards</P><P>Marco</P></BODY></HTML> Wed, 24 Sep 2014 05:42:14 GMT MarcoWedel 2014-09-24T05:42:14Z Average Time https://community.qlik.com/t5/QlikView/Average-Time/m-p/678907#M1060483 <HTML><HEAD></HEAD><BODY><P> How to calculate average time between 2 row?</P><P>Please find the attached scenerio....</P></BODY></HTML> Wed, 24 Sep 2014 05:25:57 GMT https://community.qlik.com/t5/QlikView/Average-Time/m-p/678907#M1060483 noman212 2014-09-24T05:25:57Z Re: Average Time https://community.qlik.com/t5/QlikView/Average-Time/m-p/678908#M1060484 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>First calculate the difference between <SPAN style="font-size: 10pt; line-height: 1.5em;">(use function ABOVEpar example) </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">two dates / hours and </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">transform</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> to </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">minutes </SPAN></P><P>then, you divide by two result (minutes) and then adds obtained minutes the first of the dates / times</P></BODY></HTML> Wed, 24 Sep 2014 05:32:27 GMT https://community.qlik.com/t5/QlikView/Average-Time/m-p/678908#M1060484 ecolomer 2014-09-24T05:32:27Z Re: Average Time https://community.qlik.com/t5/QlikView/Average-Time/m-p/678909#M1060485 <HTML><HEAD></HEAD><BODY><P>Timestamp(Numavg(timestamp1, previous(timestamp1)))</P><P>?</P><P></P><P>hope this helps</P><P>regards</P><P>Marco</P></BODY></HTML> Wed, 24 Sep 2014 05:42:14 GMT https://community.qlik.com/t5/QlikView/Average-Time/m-p/678909#M1060485 MarcoWedel 2014-09-24T05:42:14Z Re: Average Time https://community.qlik.com/t5/QlikView/Average-Time/m-p/678910#M1060486 <HTML><HEAD></HEAD><BODY><P>Hi Noman,</P><P></P><P>Try this</P><P></P><P>Timestamp(Numavg(timestamp1, previous(timestamp1)),'MM/DD/YYYY hh:mm:ss')</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Wed, 24 Sep 2014 06:07:50 GMT https://community.qlik.com/t5/QlikView/Average-Time/m-p/678910#M1060486 jyothish8807 2014-09-24T06:07:50Z