Convert duration to HH:MM:SS in Alteryx

In this video I will show you how to convert a duration string into proper HH:MM:SS format that can be used in Alteryx. In this example we are presented with durations that exceed 24 hours and will not automatically fit into the Time Type in Alteryx. In order to get our duration to be within 0-24 hours we use a MOD function that gives us the remainder after division.