Hi All,

I have a column containing times values that I would like to reformat into hh:mm:ss and remove the brackets. The time values are not a fixed length but are separated by either a colon ( or decimal point (.)

Here are 3 examples:

(0:0:9.0)
(0:15:0.0)
(0:10:37.0)

I would like to remove the ms value (.0) and reformat to hh:mm:ss therefore the values above would be

00:00:09
00:15:00
00:10:37

I'm not sure if this is possible?