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

1 vue (au cours des 30 derniers jours)
Fatemah Ebrahim
Fatemah Ebrahim le 27 Fév 2019
Réponse apportée : Jeremy Hughes le 27 Fév 2019
The dataset is a 83520x10 table so how would I do that for something of this size?

Connectez-vous pour répondre à cette question.

Réponses (2)

madhan ravi
madhan ravi le 27 Fév 2019
doc ymd
doc hms
Jeremy Hughes
Jeremy Hughes le 27 Fév 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')

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by