Different Time Formats in the same column

[#1]

Hi,

I have a column containing data of different timings. I would like to know how I can convert all the timings to the same format as they are of different formats.

Race Timings

51.98 (this is in seconds:milliseconds)

52.00

52.19

01:55.8 (this is in minutes:seconds:milliseconds)

02:15.3

When I try to format all to min:s with input format as min:s, all data with seconds:milliseconds gets removed.

[#2 · Accepted solution]

Hi @reynardlam94 

I wonder if this solution works for this case:

https://www.youtube.com/watch?v=NzbjVs0o6No

please do let us know if it did.

[#3]

I would write a simple For Each Row(), and add in the minutes value when there isn't one

For Each Row(
  If(contains(:Race Timings, ":") == 0,
     :Race Timings = "00:" || :Race Timings
  )
)

Then you will be able to convert the column using the informat method