I need help on Google Sheets/Excel.
I extracted sports results data with the IMPORTHTML function of Google Sheets.
All the cells in the Result column contain a duration in the form of "m:ss.00" but stored as text (eg: 3:34.56 for 3mn, 34sec, 56).
How can I convert this data to an actual duration format (mm:ss.00)?
Cheers
IMPORTHTML
is only available in Google Sheets.