How to sum duration

[#1]

Hi,

I have duration datas, with this format : 02:15:45 means 2 hours, 15 minutes and 45 seconds.

I have to calculate sum and average duration and show it with the same format.

I can't find any function easy to use. Did I miss something ?

Thanks,

[#2 · Accepted solution]

Hi,

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.

I put a small example on here.

Cheers,

Nigel.

[#3]

Oups, thanks, and sorry for that...

[#4]

Hi there,

But how to show it when the result is greater than 24:00:00.

Best Regards,

Javier Pozo

[#5]

Hello,

I Just found the answer here: http://community.qlik.com/forums/p/26332/100842.aspx#100842

I have to use: interval(Sum(Duration),'hh:mm')

Best Regards,

Javier Pozo