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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.