This macro basically takes a column with time as decimal values (1.50 hours) and gives you a new column with the right time format (1:30) (HH:MM). This is useful mostly for dashboards and to have better visualization of time, easier to know a delivery takes 1 hour and 57 minutes, than 1.95 hours.
Hello,
Thank you for your contribution. If you have not done so, I would recommend you check out the Alteryx marketplace, where you can share your macros for others to download and leverage within their own workflows:
https://marketplace.alteryx.com/en-US/home
Thank you,