topic Different Time Formats in the same column in Discussions

Different Time Formats in the same column

reynardlam94 — Sat, 10 Jun 2023 23:36:32 GMT

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.

Re: Different Time Formats in the same column

ron_horne — Sun, 05 Sep 2021 14:52:19 GMT

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.

Re: Different Time Formats in the same column

txnelson — Sun, 05 Sep 2021 15:38:44 GMT

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