Convert Numbers of seconds in Hours

[#1]

Hi,

I have a problem with the time in Qlikview. I Have a field which is the numbers of seconds.

In the dashboard I want see the average of this number for each dimension. But this average must be in Hours (19h27 min for example)

Have you an idea for the expression which I must used please?[:)]

Thanks for your help

[Anonymous]

Hello Manuel,

in my case below one shows(127200 seconds) 35h 20min same want see in days like 4 days 3 h 20 min

FLOOR((AVG(SECONDS)/3600))&'h'&ROUND(MOD(ROUND(AVG(SECONDS)),3600)/60)&'min'

Thanks & Regards,

Nagesh