Hi,
I have an employee schedule at work that I want to update to speed
entry of all times. Currently, every cell that is time is formatted as
such, and to get 6:00 PM, I type in 18:00 (I find it easier to think in
military time when using excel).

However, what I want is some code so that I can leave out typing the
colon. Hence, I want to be able to type in 1800 and have excel
automatically change that to 6:00 PM.

How do I accomplish this?

Thanks in advance,
Scott


--
WinterCoast
------------------------------------------------------------------------
WinterCoast's Profile: http://www.excelforum.com/member.php...o&userid=21044
View this thread: http://www.excelforum.com/showthread...hreadid=386646