I wasn't advocating the colon method, just stating that with having to
*TEMPORARILY* set the Autocorrect to replace colon with dot, and still
having to enter that character, it's advantage over the colon method is
slight, and Chip's solution leaves it trailing in it's wake

Bob

PS setting autocorrect isn't on the numeric keypad either!


"Biff" wrote in message
...
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
.



.



.