PDA

View Full Version : Solved: date and time score as text



chungtinhlak
01-16-2009, 03:58 PM
If i have dates and time in text format stored this way. what's the quickiest way to get it back into the proper format?




2008/11/21 13:26:08
2008/04/01 15:55:55
2008/10/03 17:56:22
2008/01/16 11:37:57
2008/10/01 19:27:13

Bob Phillips
01-16-2009, 05:32 PM
If you don't mind separtae cells, you could select the column, Data>Text To Columns, and step through until step 3 and select the Date option.

chungtinhlak
01-16-2009, 05:44 PM
thanks xld, after looking through google, i found this method that works best.
have another column
LET X BE THE COLUMN WHERE YOU DATE AND TIME IS STORE

=datevalue(X) + TIMEVALUE(X)

THANKS FOR YOU HELP