How do I split the date & time into two separate columns?

After I imported this data, the date and time is in the same column in the format of "mm/dd/yyyy hh:mm:ss" military time. How do I write a VBA code to split up the date and time into two separate columns. One column would only have "mm/dd/yyyy" while the other only have "hh:mm:ss" in military time.

Eventually, I need to extract information from the data by looking for a specific time. I would also plot time vs something.

I don't know if treating it as a string would work, because it would just become a text rather than a time, right?

Please Login or Register  to view this content.

Thanks Ranman. It was like magic! This is also the first time I heard of the While - Wend statement. I usually only use the While - Loop statement. Cool.

xladept, who is "Nanner."

This worked, too! Thanks! However, I am not too familiar with the "Sub SplitLongData(): Dim D" statement.

xladept, who is "Nanner?"

This worked, too! Thanks! However, I am not too familiar with the "Sub SplitLongData(): Dim D" statement.

Thanks AlKey. I actually need to write it in VBA. But what you suggested is useful for times when I just want to do it manually. Thanks!

I didn't know about the trick with the colon. Thanks!

Hey xladept, I've been using your code to split up the date and time. However, I just realized that it does not maintain the data in military time when I run it.

My DateTime data is in the form of "8/22/2014 00:00:10." But when I run your code to split up the date and time, I get "8/22/2014" and "12:00:10" in separate cells instead of "00:00:10." This causes problems for me now, because I want to also convert the hh:mm:ss into decimal format.

Thanks.

xladept, I tried general formatting. It doesn't do anything. It's already in the correct format of "hh:mm:ss." Even when I try to format it in military time, it still reads it as 12:00:10 instead of 00:00:10.

Okay, I think the file is attached. Thanks for your help!

Thanks xladept. It works.