Sports timing in 1/100 sec

  • Thread starter Thread starter John Wright
  • Start date Start date
J

John Wright

I have the latest 2003 excel and want to record swimming times in mm:sec:00
(1/100)but I see that in formatting cells you can only record times in
mm:sec:0 (1/10). Is it possible to write a macro to carry out this
operation. Nearly all sports time in 1/100th of a second and it would be a
really useful add-on

John
 
Am I a dummy or what

I just found out how to do it. You select custom and then just add in the
extra 0 at the end of the mm:sec:0 and this works
 
Also, I would use a format of mm:ss.00

The period signifies a base 10 number, whereas minutes and seconds are base
60.
 
Back
Top