parsing a date and time field

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?
 
N

ND Pard

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

parsing a date and time field 5
Countdown macro - display settings 2
Date and Time Picker 6.0 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
How to Create an S-Curve from Custom Field? 0
Special converting of string date&time to date format 4
Date and Time 1

Top