Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.) |
#2
|
|||
|
|||
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoid user having to enter 00 hours when using [mm]:ss format | Excel Discussion (Misc queries) |