Entering time

[Guest]

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?

 

[Peo Sjoblom]

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)

 

[T. Valko]

See this:

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

Another alternative is to *temporarily* set auto correct to replace a
character. For example, using 10 key you are probably comfortable with the
decimal point key (from an ergonomic standpoint).

Set auto correct to replace the decimal point with the colon:

Type:

8.00
11.45

Auto correct changes it to:

8:00 AM
11:45 AM

You'd have to enter the numbers based on a 24 hr clock, though.

13.15

Auto correct changes it to:

1:15 PM

And then you'd have to remember to delete the auto correct setting after you
were done.

Biff

 

[Guest]

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

Format cell as:

0":"00

 

[Guest]

Thanks!! The autocorrect is easier for me but it does the job. Again Thank you