Split datetime to date and time

**mdek** · 02-05-2016, 05:36 PM

Hi

I have a sheet with datetime in one cell, now i want to split it date and time seperate.

Can this in VBA?

**JieJenn** · 02-05-2016, 05:42 PM

Can you use TextToColumns? Convert your cell to Short Date format and use Text To Columns to separate Date and Time.

**mdek** · 02-05-2016, 05:50 PM

The field is a datetime field, it comes from a database, the split has to be done very ofter so a macro is best i think

**Raymundus** · 02-05-2016, 05:53 PM

You will find this link useful...

http://www.laurii.info/2012/10/vba-s...e-time-column/

Re: Split datetime to date and time