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

1 visualización (últimos 30 días)
Fatemah Ebrahim
Fatemah Ebrahim el 27 de Feb. de 2019
Respondida: Jeremy Hughes el 27 de Feb. de 2019
The dataset is a 83520x10 table so how would I do that for something of this size?

Iniciar sesión para responder a esta pregunta.

Respuestas (2)

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

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by