Conversion from- "HH:MM:SS" to "Hours:Minutes:Seconds"

[EN6924]

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..

[Qiu · Accepted solution]

@EN6924 
I blieve you almost get there.
I assume you dont want the leading zero as well.

[binuacs]

@EN6924  other option using datetinme formula

DateTimeFormat((DateTimeParse("2021-01-01" + [Time],"%Y-%m-%d %H:%M:%S")),"%H") + " Hours " + DateTimeFormat((DateTimeParse("2021-01-01" + [Time],"%Y-%m-%d %H:%M:%S")),"%M") + " Minutes " + DateTimeFormat((DateTimeParse("2021-01-01" + [Time],"%Y-%m-%d %H:%M:%S")),"%S") + " Seconds"

[Qiu · Accepted solution]

@EN6924 

Thank you for accepting my answer.

I am thinking sumit this one as a weekly challenge idea. Hope you will not opose it. 😁