View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Billigmeier
 
Posts: n/a
Default Time Display in a Stop Watch fromat

Use a custom format of:

hh:mm:ss


--
Regards,
Dave


"Gabe" wrote:

Is there a way to format a cell's time in a "stop watch" format, without the
date prefix or the AM/PM. Currently (1/1/1900 12:00:00 AM) Suggested (0:00).
Any help is greatly appriciated. Thanks.