If you don't use any further calculation then try this:

Format cell as:

0":"00


"Chris" wrote:

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?