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