topic How to sum duration in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145641#M24313 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I Just found the answer here: <A href="http://community.qlik.com/forums/p/26332/100842.aspx#100842">http://community.qlik.com/forums/p/26332/100842.aspx#100842</A></P><P>I have to use: interval(Sum(Duration),'hh:mm')</P><P>Best Regards,</P><P>Javier Pozo</P></BODY></HTML> Sat, 06 Mar 2010 17:57:08 GMT 2010-03-06T17:57:08Z How to sum duration https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145637#M24309 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have duration datas, with this format : 02:15:45 means 2 hours, 15 minutes and 45 seconds.</P><P>I have to calculate sum and average duration and show it with the same format.</P><P>I can't find any function easy to use. Did I miss something ?</P><P>Thanks,</P></BODY></HTML> Tue, 02 Jun 2009 22:20:31 GMT https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145637#M24309 2009-06-02T22:20:31Z How to sum duration https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145638#M24310 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Sum(Duration) should work, the "trick" if there's a trick is to go to the Number Tab of the chart properties and make sure that the expression is set to show in a Time Format.</P><P>I put a small example on here.</P><P>Cheers,</P><P>Nigel.</P></BODY></HTML> Tue, 02 Jun 2009 22:29:08 GMT https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145638#M24310 2009-06-02T22:29:08Z How to sum duration https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145639#M24311 <HTML><HEAD></HEAD><BODY><P>Oups, thanks, and sorry for that...</P></BODY></HTML> Tue, 02 Jun 2009 23:06:59 GMT https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145639#M24311 2009-06-02T23:06:59Z How to sum duration https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145640#M24312 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>But how to show it when the result is greater than 24:00:00.</P><P>Best Regards,</P><P>Javier Pozo</P></BODY></HTML> Sat, 06 Mar 2010 02:02:16 GMT https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145640#M24312 2010-03-06T02:02:16Z How to sum duration https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145641#M24313 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I Just found the answer here: <A href="http://community.qlik.com/forums/p/26332/100842.aspx#100842">http://community.qlik.com/forums/p/26332/100842.aspx#100842</A></P><P>I have to use: interval(Sum(Duration),'hh:mm')</P><P>Best Regards,</P><P>Javier Pozo</P></BODY></HTML> Sat, 06 Mar 2010 17:57:08 GMT https://community.qlik.com/t5/QlikView/How-to-sum-duration/m-p/145641#M24313 2010-03-06T17:57:08Z