Let's assume, the time taken to complete a job shows in HH:MM:SS format i.e.,


Q. How do I convert the entire column to - let's say Row 1 would be 57 Minutes 59 Seconds?
I did it but it's the correct result -
1. Changed the column data type to - V_String
2. Applied Text to column, Delimiter ":"
3. Connected a formula tool -- [1]+" "+"Hours" +" "+ [2]+" Minutes" +" "+ [3] +" Seconds"

Please guide me..