Thank you. I have no problem with military conversion when using hours,
minutes and 10 key.... however the other dept. that are keying want to put
time as traditional 24 hour clock with traditional 60 minute /minutes... I
like your suggestions. Thanks!

"Biff" wrote:

Oh....

The decimal point IS ON the numeric keypad....

The COLON IS NOT.

Biff

-----Original Message-----
You may know more payroll clerks than me, but I doubt it,
it still requires
coming off of the number keypad that those type of users
will use more than
perhaps you or I. And if they don't know about Chip's
solution, educate
them!

Bob

"Biff" wrote in message
...
but is it any easier than the 24 hour clock with colon?
One shift hardly does it for me.

Ah, but that one shift requires two hands!

Payroll clerks/timekeepers that either don't want to use
the VBA method or don't know about it will really
appreciate the difference.

Biff

-----Original Message-----
but is it any easier than the 24 hour clock with colon?
One shift hardly
does it for me.

Bob

"Biff" wrote in message
...
Hi!

An alternative to the VBA solution is to
*TEMPORARILY*
set
AutoCorrect to replace a period "." with the
colon ":"
and
enter the "times" like 12.34. You would have enter
the
times in a 24 hr clock format but can reformat them
after
they've all been entered.

This is lots faster and easier than using the 1 2
shift
colon 3 4 space P M method.

Just remember to reset AutoCorrect after you're done.

Biff

-----Original Message-----
I am trying to type in 12:34 as 1234(for example)
and
have the format convert
it back to 12:34 Is there a way of formatting this
conversion? I will need it
to be a time format since it is a time card key
entry.

Thanks
--
Danlinksman
.



.



.