MATLAB Answers

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

Fatemah Ebrahim 님이 질문을 제출함. 27 Feb 2019
최근 활동 Jeremy Hughes 님이 답변함. 27 Feb 2019
The dataset is a 83520x10 table so how would I do that for something of this size?

  댓글 수: 0

로그인 to comment.

태그

답변 수: 2

madhan ravi 님의 답변 27 Feb 2019

doc ymd
doc hms

  댓글 수: 0

로그인 to comment.


Jeremy Hughes 님의 답변 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')

  댓글 수: 0

로그인 to comment.



Translated by