If you prefer a *non-code* work-around, you could use "AutoCorrect".

<Tools <AutoCorrect
In the 'Replace' box, enter 2 periods ( .. ),
In the 'With' box, enter a colon ( : ),
Then <OK

Now, when it's necessary to enter times, keep your fingers on the num keypad
and enter
9..
And you'll get 9:00 AM,

Enter
12..45
And you'll get 12:45 PM

Neat trick for folks who are adept in 10 key!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ThereJustNow"
wrote in message
news:ThereJustNow.29v53c_1151079605.9519@excelforu m-nospam.com...

I use Excel to enter the start and end time of an employee and the 3rd
cell calculates the number of hours worked. The formula works great,
however it would be so much faster if I could avoid having to type the
":" each and every time.

Is there a way to add the semicolon automatically, or alternately have
the ability to type "1400" and have it see "14:00"?

Thanks very much,

James Norton


--
ThereJustNow
------------------------------------------------------------------------
ThereJustNow's Profile:
http://www.excelforum.com/member.php...o&userid=35720
View this thread: http://www.excelforum.com/showthread...hreadid=555035