RunTime in seconds to Runtime in minutes

[jasmeenkr]

Hi ALl,

I have field Runtime with values in seconds- sum(Runtime).How to get Runtime in minutes in qliksense load script

[rwunderlich]

Interval(Interval#(sum(Runtime), 's'), 'm:s')

or if you only need whole minutes:

round(Sum(Runtime) / 60)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[sunny_talwar]

May be divide it by 60?

Sum(runtime)/60

or

Interval(Interval#(Sum(runtime), 'ss'), 'mm:ss')

[jasmeenkr]

What does divide by Sum(Runtine in seconds)/86400 would do ?

What does Sum(runtime in seconds)/1440 would do?

[sunny_talwar]

Hey Rob - 

'm:s' might not show the correct seconds... although underlying value will be correct. I think 'm:ss' would be correct

[sunny_talwar]

24*60*60 = 86400 will convert seconds into days

24*60 = 1440 will convert minutes into days... but won't really mean much for seconds

[jasmeenkr]

Ok.Thanks

in case I have to show runtime over span of days shown in another chart, I should divide it by(86400)