Convert Minutes (MM) to HH:MM

Question

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 Answer

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

binu_acs · Accepted Answer

@Mr_Raks

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