Adding the semicolon automatically in date format

[ThereJustNow]

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?action=getinfo&userid=35720
View this thread: http://www.excelforum.com/showthread.php?threadid=555035

[Chip Pearson]

You can't do it with formatting. You need a VBA event procedure.
See www.cpearson.com/excel/datetimeentry.htm for example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"ThereJustNow"
<ThereJustNow.29v5...@excelforum-nospam.com> wrote
in message
news:ThereJustNow.29v5...@excelforum-nospam.com...

[Ragdyer]

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" <ThereJustNow.29v5...@excelforum-nospam.com>
wrote in message
news:ThereJustNow.29v5...@excelforum-nospam.com...
>