I have an array of date time values. How do I separate Date and time and enter it in separate columns in excel?
조회 수: 1 (최근 30일)
이전 댓글 표시
The dataset is a 83520x10 table so how would I do that for something of this size?
댓글 수: 0
답변 (2개)
Jeremy Hughes
2019년 2월 27일
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Dates and Time에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!