race results in minute:seconds.hundredth sec

[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?

 

[Lars-Åke Aspelin]

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?

Try the following custom format for your cell formatting.

mm:ss.00

Hope this helps / Lars-Åke

 

[Chris]

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