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!
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!
See http://www.cpearson.com/excel/DateTimeEntry.htm
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Lexicon" <[email protected]> wrote in message
news:[email protected]...
> 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!
I don't know if this is the quickest or best way, but try entering the
time with a space or a period in between the HH MM SS, then when all is
entered do a Search Replace (ctrl H) and replace the space or period
with the colon.
Dennis
You can format the cell with the following custom code: 00\:00\:00
Be aware that this is only showing as hh:mm:ss
Example: typing 100 (or 0100) will show 00:01:00
typing 10010 will show 01:00:10
If you format the cell with 00\:00 it's showing hh:mm.
--
Message posted via http://www.officekb.com
Thanks everyone - really helpful stuff - I have now impressed everyone in the
office!!!!!!
"Lexicon" wrote:
> 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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks