Format Duration in DD:HH:MM:SS

[Femi_Olunuga]

Good Afternoon,

I have an issue that is giving me sleepless night.

I have a duration column (one is Resolution time (in hrs)) in my data, some entries are more than 24 hours( some are like 79:45:52) and I want to present it in DD:HH:MM:SS as I understand the Alteryx doesn't identify any time format more than 24 hours, How can i go about it.

Here is a structure of my data

[atcodedog05]

Happy to help : ) @Femi_Olunuga 

Cheers and have a nice day!