convert Date Time format

**yourskarthik** · 12-30-2009, 12:27 PM

Need VBA Script to convert DateTime format to Date and Time in separate columns

Details:

I have a cell with 30/12/2009 00:01:16 (DATETIME format), I need to separate the date and time in two separate columns

Is there any macro instead of using TEXT TO COLUMNS to do this?

**Leith Ross** · 12-30-2009, 12:40 PM

Hello yourskarthik,

I doubt you need VBA to do this if the information is already on the worksheet. You could do this by changing the cell formatting and copying the date into the appropriate cells using formulas. What are you doing that makes you think you need a VBA solution?

**yourskarthik** · 12-30-2009, 12:47 PM

Hello Leith Ross,

I have the data in the excel but the thing is Column A contains Time Stamp in DATETIME format (Please see the attached)

I need to have column B with DATE and Column C with Time (HH:MM format instead of HH:MM:SS)

Yes I can do this by changing the format but everytime I have to do TEXT TO COLUMNS and then change the format which is annoying..

**royUK** · 12-30-2009, 01:04 PM

Surely you can pre-format the columns. Text to Columns splits the time element to Column B which I had already formatted as hh:mm with no problem

**Leith Ross** · 12-30-2009, 01:29 PM

Hello yourskarthik,

It would be easier to understand what you need if you could post a workbook with the data imported using text to columns. If you do need a macro for this then knowing the data layout is essential.