calculate swim times

S

saladbar

Hi,
How can I track swim event times - mm:ss.ms format? I need to go two digits
deep in the MS format. This is to be used to track swimmer's times and
chart progress.

Thank you all for your time and help.
 
A

Amedee Van Gasse

saladbar schreef in
How can I track swim event times - mm:ss.ms format?
Click to expand...

Cell Properties - Numberformat:
mm:ss.00

--
Amedee Van Gasse
http://www.amedee.be

To top-post is human, to bottom-post and snip is sublime.

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.
 
N

Norman Harker

Hi Saladbar!

Enter the start and stop times as per the watch / clock

hh:mm:ss.00

Elapsed time
=StopTime-StartTime
Format mm:ss.00
 
S

saladbar

Thank you all for your time, I really appreciate it!

I am using Excel 2000, and it seems that this version will roll up to 1/10s
of a second (rounds up .27 to .3). The only place I can find a way to
modify things is by the following position from the toolbar:

format- cell - special mm:ss:0
A similar method appears when I use format - time - 02:57.0

Does this version of excel only go 1 digit deep? I don't want to
overextend my welcome, but I appreciate any suggestions. Thank you again
for your time!
 
J

JE McGimpsey

For me, the display defaults to 1 decimal digit unless I format the cell
to show two, as in my other reply.

You can either preformat or format after entry.
 
Top