parsing a date and time field

  • Thread starter Thread starter freeriderxlt
  • Start date Start date
F

freeriderxlt

I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
 
Try using the TimeValue and DateValue functions.
First format your columns to a Date and Time format respectively.

Assuming your downloaded data is in cell A1, in the column you gave a Date
format to type the formula: =Datevalue(A1).

I think you will get your desired results. Good Luck.
 
Back
Top