View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
dennis dennis is offline
external usenet poster
 
Posts: 202
Default Time format as hh:mm:ss

When inputing time as above, Excel is thinking it is a Time as AM or PM, but
actually it is a lapsed time. How do I get it to do just hh:mm:ss? Without
placing in the : each time would be a timesaver as well.

Regards,
--
Dennis