Hi All, I have tried doing this with formulas but cannot seem to get it to work.

I have a load of swimming times some as mm:ss.00 some as just ss.00 if under 1 minute, none of them go into over 1 hour.

so in a column in no particular order, i have some times like 01:15.90 or 05:25.79 (mm:ss.00) in others I would only have 32.40 or 50.98 (ss.00)

I need to copy the time formatted cell to the cell to the right as text formatted, so I can then use a mail merge, the mail merge I am using does not like the time format and changes it to a time (am/pm)

I am happy to do this with a formula if someone knows how but I have tried and unless I am missing something I cannot get it to work.

Hope I have covered everything.

Darren