Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can you input time (hh:mm:ss) without having to input the colon i.
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - Information with time and date | Excel Discussion (Misc queries) |