Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert seconds to minutes

Hello everyone,

I have a field 'Call Duration' where the values are in seconds eg. 120.5, 130.2, 150. So, is there a way from where we could convert this into minutes. For gg. 120 will be considered 02:00 minutes and 150 will be considered as 02:30.

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

I got it.

You will have to divide the field with total no. of seconds in the day i.e. 86400 and in the properties of chart in number tab you will have to choose Time and  remove h and TT which will look like mm:ss after modified.

Thanks everyone.

View solution in original post

4 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

try below

=interval(timestamp#(120, 's'), 'm')

Regards

ASHFAQ

Not applicable
Author

Thanks Ashfaq, but it didn't work.

Not applicable
Author

I got it.

You will have to divide the field with total no. of seconds in the day i.e. 86400 and in the properties of chart in number tab you will have to choose Time and  remove h and TT which will look like mm:ss after modified.

Thanks everyone.

agomes1971
Specialist II
Specialist II

I got the same answer than you using a excel sheet for calculations.

Nice!!!

André Gomes