microsoft.public.windowsxp.customize

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