I have a two part question but if anyone has an answer to even one of
these my problem will be solved!!

I am entering time into a spreadsheet using a 24 hour clock, for
example:

A1 23:30
A2 08:00

The problem is.... I am doing this in mass quantities and would like to
use the number pad exclusively. So if anyone can tell me

1) Is there a way that I can create a shortcut so that a key or
combination of keys on the number pad will enter a colon?

AND/OR

2) Is there a way I can format the cells so that when I enter the 4
digits it will automatically format to enter the colon in the
appropriate place?

I have experimented at length with option 2 and have become frustrated.
I used "format - numbers - time" but it does not matter if I format
then enter the numbers or enter the numbers then format - it turns my
numbers to 0:00 I am hoping someone has run into this and can help.


--
transpark