View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default how can I work with lap times?

Hi,

Format you cell with

mm:ss.000



Mike



"Fonz" wrote:

I need to format and work with lap times in the form mm:ss:ttt (minutes,
seconds and thousandths). I cannot find out how to format these so that I can
perform comparisons on them and draw up charts. Can anybody help me? I know
about "Format Cells" of course but don't seem to find any suitable choices
listed.