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)
Mostrar comentarios más antiguos
The dataset is a 83520x10 table so how would I do that for something of this size?
0 comentarios
Respuestas (2)
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')
0 comentarios
Ver también
Categorías
Más información sobre Dates and Time en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!