Time format as hh:mm:ss

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dennis <Dennis@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 28 Jan 2009 12:52:01 -0800

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
.

Follow-Ups:
- RE: Time format as hh:mm:ss
  - From: Shane Devenshire
- Re: Time format as hh:mm:ss
  - From: Niek Otten

Prev by Date: Re: How do I find a Free Downloadable wedding program on here?
Next by Date: Re: Formatting cells
Previous by thread: Converting Dates after Import
Next by thread: Re: Time format as hh:mm:ss
Index(es):
- Date
- Thread