Adding the semicolon automatically in date format
 

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

Adding the semicolon automatically in date format
 

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"
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

Adding the semicolon automatically in date format
 

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