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
.