formatting cells for time
 

How do you format cells for time so that you can enter only the numbers and
not the colon? We have a ss that we enter many times and it would be much
faster if we didn't have to enter the colons.

formatting cells for time
 

http://www.cpearson.com/excel/DateTimeEntry.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"rjpalmateer" wrote in message
...
How do you format cells for time so that you can enter only the numbers
and
not the colon? We have a ss that we enter many times and it would be much
faster if we didn't have to enter the colons.