Convert Minutes (MM) to HH:MM

[Mr_Raks]

Hello All, I am beginner in alteryx and have a query regarding one of the projects i am working.

I have a data with Total minutes (80, 6000 etc.). I need to convert them to HH:MM (01:20 , 100:00 ). Is there a way i can do it. I went through few articles but couldnt find a solution. 

Thank you in advance.

[alexnajm · Accepted solution]

What articles did you see? This seems to have a valid solution: Solved: Time Conversion - Seconds to HH:MM:SS - Alteryx Community

You can adjust as needed to avoid seconds

[binuacs · Accepted solution]

@Mr_Raks 

PadLeft(ToString(Floor([Minutes] / 60)), 2, "0") + ":" + PadLeft(ToString(MOD([Minutes] , 60)), 2, "0")