# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for
Did you mean:
Contributor

## RunTime in seconds to Runtime in minutes

Hi ALl,

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

Labels (3)

• ### Times

6 Replies
MVP

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

or if you only need whole minutes:

round(Sum(Runtime) / 60)

MVP

May be divide it by 60?

Sum(runtime)/60

or

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

Contributor
Author

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

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

MVP

Hey Rob -

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

MVP

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

Contributor
Author

Ok.Thanks

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