How about this:

Format | Cells | Custom
enter the format:
00":"00":"00

Richard



"leah" wrote in message
...
I am trying to enter times (00:01:42) without having to enter the colons (I'm
lazy). I found out how to do it by a post on 11/2/04 which referred to this
site:
http://www.cpearson.com/excel/DateTimeEntry.htm
I copied the time program over into Excel Visual Basic, but I must be
missing something b/c it doesn't work.

leah