calculate swim times

  • Thread starter Thread starter saladbar
  • Start date Start date
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.
 
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.
 
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
 
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!
 
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.
 
Back
Top