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.