race results in minute:seconds.hundredth sec

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I need to track and post race results using mm:ss.xx format. I also need to
add/subtract times. Is there a function or format to do this?
 
I need to track and post race results using mm:ss.xx format. I also need to
add/subtract times. Is there a function or format to do this?
Click to expand...

Try the following custom format for your cell formatting.

mm:ss.00

Hope this helps / Lars-Åke
 
It works if there are minutes. If the results are less than a minute, it
converts it to hours. To get around this, all I can do is add leading zeros.
If there is another way, let me know. Otherwise, we'll stay this this
approach.

thanks for your help...it is greatly appreciated.
Chris
 
Back
Top