Convert this Time format to Timestamp

[SK28]

Hi

I have a JSON file as the data source.

The 

I have a column as shown below it's a Time 

Below is the format --> timezone<hh>H<mm>M<ss>S

Run_Time

PT00H00M00S

PT01H02M34S

PT02H03M23S

so on

Below is the format --> timezone<hh>H<mm>M<ss>S

let's take PT01H02M34S as example

Timezone - PT, H = hour, M = Minutes and S = Seconds

01 is the hours[hh]

02 is the Minutes[mm]

34 is the seconds [ss]

The requirement is to convert 

PT01H02M34S  into = 01:02:34 

Can anyone help me on this please,.

Appreciate your  efforts

[BrunPierre · Accepted solution]

Hi @SK28, try this.

Time(Time#(PurgeChar(Run_Time,'ABCDEFGHIJKLMNOPQRSTUVWYZ'),'hhmmss'),'hh:mm:ss')

[SK28]

Thanks @BrunPierre  I wasn't Feeling well, Apologies for the late response!