I have an array of date time values. How do I separate Date and time and enter it in separate columns in excel?

The dataset is a 83520x10 table so how would I do that for something of this size?

Answer 1

[madhan ravi]

doc ymd 
doc hms

Answer 2

[Jeremy Hughes]

Assuming you have a datetime array called DateAndTime which is a column vector:

Date = dateshift(DateAndTime,'start','day')

Time = timeofday(DateAndTime)

writetable(table(Date,Time),'file.xlsx')