How to take average for HH:mm:ss

[viveksairam89]

Hi,

I am trying for a expression someone can help me for taking Average for hh:mm:ss

I have converted Seconds to hh:mm:ss

Used expression Avg(waittime/3600)

In excel when we calculate its perfect but in qliksense getting a different average

[sunny_talwar]

Would you be able to share the sample data you tried to work with in Excel?

[viveksairam89]

i have converted seconds to hh:mm:ss using 3600

and applied Avg(waittime/3600)

0:00:00

3:35:12

0:36:00

Average in Excel=1:23:44 showing correct

But iam not getting this value in qliksense

[sunny_talwar · Accepted solution]

Seems to be working for me