topic Re: Convert Seconds into Hours in QlikView

Convert Seconds into Hours

Thu, 05 Feb 2015 15:29:53 GMT

Hi Everyone,

I need some help here.

I have a field coming in from a SQL database called business_stc and this field is a time it took to close a ticket in seconds. I have the need to convert this into hours and then somehow convert 8 hours into 1 business day.

Re: Convert Seconds into Hours

avinashelite — Thu, 05 Feb 2015 15:30:45 GMT

try like this;

secondsfeild/360 this will convert hrs

Days conversion:

(secondsfeild/360)/8 as days

Re: Convert Seconds into Hours

NickHoff — Thu, 05 Feb 2015 15:32:19 GMT

Why not just multiply it? Really if you multiply Interval(Interval#(business_stc,'ss'),'d hh:mm:ss') by 3 shouldn't that give you an 8 hour day?

To convert the seconds into hours though you can use the following:

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

Re: Convert Seconds into Hours

MarcoWedel — Thu, 05 Feb 2015 15:37:53 GMT

Interval(business_stc/86400)

Re: Convert Seconds into Hours

MarcoWedel — Thu, 05 Feb 2015 15:44:33 GMT

or for 8 hours per day:

=Dual(Div(business_stc,28800)&' '&Interval(fmod(business_stc,28800)/86400, 'hh:mm:ss'), business_stc)

hope this helps

regards

Marco

Re: Convert Seconds into Hours

Thu, 05 Feb 2015 16:09:54 GMT

Thank you. I was able to enter the above in my script and create a new field.

Re: Convert Seconds into Hours

MarcoWedel — Thu, 05 Feb 2015 16:35:12 GMT

You're welcome

regards

Marco