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

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"SeanP" wrote in message
...
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.)