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

2 visualizzazioni (ultimi 30 giorni)
Fatemah Ebrahim
Fatemah Ebrahim il 27 Feb 2019
Risposto: Jeremy Hughes il 27 Feb 2019
The dataset is a 83520x10 table so how would I do that for something of this size?

Accedi per rispondere a questa domanda.

Risposte (2)

madhan ravi
madhan ravi il 27 Feb 2019
doc ymd
doc hms
Jeremy Hughes
Jeremy Hughes il 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')

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by