Removing values and reformatting time array - VBA

[rtcwlomax]

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?

[rtcwlomax]

Haha...didn't mean to enter smiley its meant to be colon ' : '

[rtcwlomax]

Solved!

Find and replace .0) with 'blank'
Find replace (
Cells automatically reformatted to hh:mm:ss