topic AW:Convert Numbers of seconds in Hours in QlikView

Convert Numbers of seconds in Hours

Wed, 21 Apr 2010 10:40:00 GMT

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

Convert Numbers of seconds in Hours

Wed, 21 Apr 2010 10:48:27 GMT

Hi,

You can convert the second to hours/minutes using time function.

Eg Time(a,'hh:mm:ss')

regards

Regards

AW:Convert Numbers of seconds in Hours

ManuelRühl — Wed, 21 Apr 2010 10:53:23 GMT

TRY THIS:

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

AW:Convert Numbers of seconds in Hours

Wed, 21 Apr 2010 11:07:26 GMT

Thanks for your help,

Time don't succeed because I have a number of Seconds.

For the second answer, I have the good result for Hour, but not for the minutes I don't know why, I don't have any minutes

AW:Re: AW:Convert Numbers of seconds in Hours

ManuelRühl — Wed, 21 Apr 2010 11:14:08 GMT

i checked it and it worked for me .....

maybe copy & paste mistake ?

AW:Re: AW:Convert Numbers of seconds in Hours

Wed, 21 Apr 2010 11:25:50 GMT

There is my line:

FLOOR((avg([CRM_STATS.response time])/3600))&' h '& ROUND((MOD(avg([CRM_STATS.response time]),3600)/60))&' min '

I try other copy past but He doesn't work

AW:Convert Numbers of seconds in Hours

ManuelRühl — Wed, 21 Apr 2010 11:58:48 GMT

The Average-Funktion returns decimals !

The modulo-function only works without.

So do:

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

AW:Convert Numbers of seconds in Hours

Wed, 21 Apr 2010 12:02:07 GMT

Thank you it's work perfectly

Re: Convert Numbers of seconds in Hours

Fri, 05 Jun 2015 11:43:24 GMT

Please can you place a set analysis example in this formula as I'm struggling pull these together.

Thanks

Re: Convert Numbers of seconds in Hours

fred_randon — Mon, 11 Jan 2016 15:47:05 GMT

Hello,

I need your help cause I have the same problem, but with a sum and it does not work

FLOOR((AVG(sum({<disposition= {'ANSWERED'}> } duration))/3600))&'h'&ROUND(MOD(ROUND(AVG(sum({<disposition= {'ANSWERED'}> } duration))),3600)/60)&'min'

the set "count({<disposition= {'ANSWERED'}> } duration)" is ok,

Could you help me please?

Re: Convert Numbers of seconds in Hours

Anonymous — Mon, 06 Feb 2017 13:45:45 GMT

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