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

3 views (last 30 days)
The dataset is a 83520x10 table so how would I do that for something of this size?

Answers (2)

madhan ravi
madhan ravi on 27 Feb 2019
doc ymd
doc hms

Jeremy Hughes
Jeremy Hughes on 27 Feb 2019
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')

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!