parsing a date and time field

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

I have a date and time field that I downloaded from a database. It
come across looking like the following:
"02/1/2009 14:37". I want to seperate the time from the date. When I
to to "Text to Columns" and parse the field it changes it to three
columns looking like this: "02/1/2009 0:00", "2:37 AM", "PM" I parsed
based on "Space delimiter". I am looking for suggestions on how to get
the correct time to display.

Replies