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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lexicon" wrote in message
...
hi - I've got lots of numbers to input - all of them are times. Does
anyone
know hoe I can input the times as hh:mm:ss without having to input the
colon
(:) inbetween the numbers everytime. Thanks!