Need character remaped, not the key

[Thomas G. Marshall]

I need to enter a number of times a time of this form into an Excel
spreadsheet:

HH:MM

And I would like to use my USB numberpad with my notebook to do this. I
would like to remap the number pad's "." key to be a ":" instead.

I have KeyTweak, and also know other ways of remapping the KEY, but this
would only do this mapping:

Numpad "." ---> ";"

(requiring the shift to gain the colon.)

Is there any way for me to map

Numpad"." ---> ":"

?

Thanks

 

[Gary''s Student]

No mapping is needed. Just enter the four digits. Say in column A we have
entered:
2341
In B1 put:
=TIME(LEFT(A1,2),RIGHT(A1,2),0)
format B1 as hh:mm and copy down

Saving a keystroke make the entry process easier.

 

[John Bundy]

This may do what you want, works for me. Go to Tools and select Auto Correct
Options and in the replace box enter . and the with box enter : and click
add. Now when you type 1.25 it enters as 1:25 and defaults format to time
automagically. When you're done select the rule you made and delete it.

 

[Thomas G. Marshall]

Gary''s Student said something like:

No mapping is needed. Just enter the four digits. Say in column A
we have entered:
2341
In B1 put:
=TIME(LEFT(A1,2),RIGHT(A1,2),0)
format B1 as hh:mm and copy down

Saving a keystroke make the entry process easier.

Ok, thanks----great idea (from both you and John Bundy). I implemented the
one you chose. Though I had to make sure that the string was prepended with
0's so that I could enter

815

and not have that be 81:15

I have a column next to each time column dedicated to inputting this,
and I have it at 25% gray, and everything but those input cells are locked
so that tabs and returns bring me only to the enterable cells.

Thanks again