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

2 views (last 30 days)
Fatemah Ebrahim
Fatemah Ebrahim on 27 Feb 2019
Answered: Jeremy Hughes on 27 Feb 2019
The dataset is a 83520x10 table so how would I do that for something of this size?

Sign in to answer this question.

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!