Solved: convert minutes (number) to hh:mm:ss - Qlik Community

cedfoning · ‎2022-12-25

hello
i have an issue

i have the following time of reception in minutes:

I want to convert it into hh:mm:ss

Any ideas ?

Thanks

Or · ‎2022-12-25

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')

Or · ‎2022-12-25

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 · ‎2022-12-27

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.

convert minutes (number) to hh:mm:ss