Working with elapsed time data

D

DW

How do I set up Excel to accept race times for a cross-
country team? I want to enter minutes and seconds for each
runner for each race. Then I want to calculate each
runner's average time.
When I enter minutes and seconds, Excel converts it to the
time of day - which is not what I want.
 

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

Format for elapsed time 2
Time Calculation 2
Time calculations 3
How can I perform calculations in Excel using time? 2
Elapsed Time formatting 3
Time format for elapsed time 4
can Excel really deal with elapsed time? 1
'auto find average of 4 fastest times' 3

Top