topic How to take average for HH:mm:ss in QlikView https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336000#M516008 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying for a expression someone can help me for taking Average for hh:mm:ss</P><P>I have converted Seconds to hh:mm:ss </P><P>Used expression Avg(waittime/3600)</P><P>In excel when we calculate its perfect but in qliksense getting a different average</P></BODY></HTML> Thu, 08 Jun 2017 13:13:33 GMT viveksairam89 2017-06-08T13:13:33Z How to take average for HH:mm:ss https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336000#M516008 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am trying for a expression someone can help me for taking Average for hh:mm:ss</P><P>I have converted Seconds to hh:mm:ss </P><P>Used expression Avg(waittime/3600)</P><P>In excel when we calculate its perfect but in qliksense getting a different average</P></BODY></HTML> Thu, 08 Jun 2017 13:13:33 GMT https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336000#M516008 viveksairam89 2017-06-08T13:13:33Z Re: How to take average for HH:mm:ss https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336001#M516009 <HTML><HEAD></HEAD><BODY><P>Would you be able to share the sample data you tried to work with in Excel?</P></BODY></HTML> Thu, 08 Jun 2017 13:26:59 GMT https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336001#M516009 sunny_talwar 2017-06-08T13:26:59Z Re: How to take average for HH:mm:ss https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336002#M516010 <HTML><HEAD></HEAD><BODY><P>i have converted seconds to hh:mm:ss using 3600</P><P>and applied <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> Avg(waittime/3600)</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 64px;"><TBODY><TR><TD align="right" class="xl63" height="20" width="64">0:00:00</TD></TR><TR><TD align="right" class="xl63" height="20">3:35:12</TD></TR><TR><TD align="right" class="xl63" height="20">0:36:00</TD></TR></TBODY></TABLE><P>Average in Excel=1:23:44 showing correct</P><P>But iam not getting this value in qliksense </P></BODY></HTML> Thu, 08 Jun 2017 13:44:15 GMT https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336002#M516010 viveksairam89 2017-06-08T13:44:15Z Re: How to take average for HH:mm:ss https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336003#M516011 <HTML><HEAD></HEAD><BODY><P>Seems to be working for me</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166213_Capture.PNG" style="height: 227px; width: 620px;" /></P></BODY></HTML> Thu, 08 Jun 2017 14:03:42 GMT https://community.qlik.com/t5/QlikView/How-to-take-average-for-HH-mm-ss/m-p/1336003#M516011 sunny_talwar 2017-06-08T14:03:42Z