How do I enter minutes and seconds (lap times)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to enter lap times from a race. These are measured in minutes and
seconds. No matter how I format the cell, I end up with dates. I want to be
able to manipulate this data (e.g. graph, sum, avg., etc.)
 
You must enter the hours: so 4 min 25 sec is entered as 0:4:25
You can format cells as mm:ss, m:ss, or mm:ss.00

best wishes
 
Back
Top