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 · Accepted solution]

Hi @Femi_Olunuga 

Here is how you can do it.

Workflow:

Hope this helps : )

[Femi_Olunuga]

It worked fine
Thanks so much.
If you have time, kindly explain the logic you used, just so that I have a better understanding for similar problem.

Thank you.

[atcodedog05]

Hi @Femi_Olunuga 

Taking hours/24 for days And hours-days*24 for hours

Happy to help : )

Cheers and have a nice day!

[Femi_Olunuga]

Thank you for your help.

I realised that the column came as a string, which means I  will not be able to carry out any calculation on them. Is it possible to convert them as an Int or any datatype that help me to perform calculations on them.

Thank you.

[atcodedog05]

Hi @Femi_Olunuga 

What kind of calculations are you looking for?

[Femi_Olunuga]

I want to be able to aggregate the duration by different dimension such as (Priority, agents, work category etc). For instance, I might want to see the entire or the average duration it takes to complete heating systems which is a job category.

[Femi_Olunuga]

@atcodedog05 Hello friend.

Wondering if you could help with this

[atcodedog05]

Hi @Femi_Olunuga 

You would need to convert it to seconds like below to perform calculations and at the end, you can convert back the format.

Hope this helps : )

[Femi_Olunuga]

Thank you much friend!

It worked