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: 
cedfoning
Creator
Creator

convert minutes (number) to hh:mm:ss

hello 
i have an issue

i have the following time of reception in minutes: 

cedfoning_0-1671976330788.png

I want to convert it into hh:mm:ss

Any ideas ? 

Thanks

Labels (3)
1 Solution

Accepted Solutions
Or
MVP
MVP

Divide the number of minutes by 1440 (number of minutes in a day) and then format as time or timestamp, e.g.

Timestamp(Temps_reception/1440,'hh:mm:ss')

 

View solution in original post

2 Replies
Or
MVP
MVP

Divide the number of minutes by 1440 (number of minutes in a day) and then format as time or timestamp, e.g.

Timestamp(Temps_reception/1440,'hh:mm:ss')

 

vinieme12
Champion III
Champion III

Use the Interval() function as below

in load script

Interval( Temps_reception,'hh:mm:ss') as Temps_reception

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.