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

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.)
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Entering Lap times 1
how can I work with lap times? 6
Lap Times 1
convert minutes to seconds 2
How do I enter accumulated time as hours, minutes and seconds? 1
stopwatch times 7
convert decimal figure to minutes and seconds 3
Time in Minutes and seconds 6

Top