parsing a date and time field

Giganews Newsgroups
Subject: parsing a date and time field
Posted by:  freeriderxlt (st.jdai…@gmail.com)
Date: Fri, 6 Mar 2009

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?

Replies