Need character remaped, not the key

I need to enter a number of times in this form:

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 do this?

Thanks

Thomas
Fri Mar 07 08:35:38 PST 2008

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

GarysStudent
Fri Mar 07 09:07:01 PST 2008

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.
--
Gary''s Student - gsnu2007e


"Thomas G. Marshall" wrote:

> 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
>
>
>

jmbundy
Fri Mar 07 09:09:01 PST 2008

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Thomas G. Marshall" wrote:

> 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
>
>
>

Thomas
Sat Mar 08 19:47:13 PST 2008

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