Different Time Formats in the same columnHi,
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.
Data TableRe: Different Time Formats in the same columnHi @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.
