T. wrote on Sun, 26 Jul 2009 19:30:47 -0400:

Assuming you use the numeric keypad to enter numbers, typing
in a decimal point should be second-nature.

**Temporarily** set an AutoCorrect option to replace . (dot,
period, decimal point) with : (colon).

Then enter the times in 24hr decimal point format. For
example, 1:45 PM gets typed in as 13.45.

After you're done make sure you delete the temporary
AutoCorrect option then format the time entries in the style
of your choice.

Also see this: quick date/time entry:

http://www.cpearson.com/Excel/DateTimeEntry.htm

Why not set a two symbol autocorrect with something you can remember and
don't other wise use like " ~; " ";s" to autocorrect to ": " ? You could
also record a macro for SHFT-; and give it an icon couldn't you?

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not