You would need VBA for that

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


Another solution would be to temporarily create an autocorrect entry where
you change a period to a colon
that would allow you to use that numpad. Of course it is very important that
you remove it when done since autocorrect works
over all office applications and could really mess up MS Word

I would go for the macro method


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Chris" wrote in message
...
I may be missing the obvious, but here goes. I have a spread sheet that I
need to enter times into. What I would like to do is use just the 10 key
to
enter 3 or 4 digit numbers tha will be display as 8:00 or 11:45. Any
suggestions?