View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_4_] Lars-Åke Aspelin[_4_] is offline
external usenet poster
 
Posts: 83
Default race results in minute:seconds.hundredth sec

On Tue, 1 Jun 2010 15:14:01 -0700, Chris
wrote:

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