Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Format Duration in DD:HH:MM:SS

Femi_Olunuga
6 - Meteoroid

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

 

 

10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Femi_Olunuga 

Cheers and have a nice day!

Labels
Top Solution Authors