I do triathlons (short ones). For each race I get 6 results:
mm:ssfor the swim
mm:ssfor the transition between swim and bike
mm:ssfor the bike
mm:ssfor the transition from bike to run
mm:ssfor the run
hh:mm:ss.tfor the overall time.
Here are my numbers:
When I paste these into Excel, it turns them into date/time values instead of leaving them as elapsed time. For example, the bike time of
43:03 is converted to
1/1/1900 7:16:00 PM.
I have tried various format settings including custom, but those seem to affect the output, not the way the numbers are evaluated when I do the paste.
Can I force them to just remain strings when I do the paste or make it turn the numbers into a number of seconds?