clueless48
New Member
- Joined
- Nov 10, 2010
- Messages
- 5
Can anyone help? I'm new to forum and this is defeating me but cannot give up!!
I have lots of swimming time data which has been input manually using a decimal instead of a colon between minutes and seconds, how can I convert this? Changing the format to this does not work as some times have minutes and some are just seconds as below :-
The times need to be in mm:ss.ms format to be able to import into a system
<tbody>
</tbody>
I have lots of swimming time data which has been input manually using a decimal instead of a colon between minutes and seconds, how can I convert this? Changing the format to this does not work as some times have minutes and some are just seconds as below :-
The times need to be in mm:ss.ms format to be able to import into a system
50 | FREE | 42.9 |
100 | FREE | 1.39.48 |
50 | FLY | 52.36 |
200 | IM | 2.46.35 |
<tbody>
</tbody>