Readtable() turns time stamp into decimal
조회 수: 8 (최근 30일)
이전 댓글 표시
I have a table with 40 columns. When I use readtable() it turns the time stamps into decimals and I don't know what the decimals mean. I need to extract the time stamps. And also I don't want the headers, but it reads them anyways.
data = readtable(filename, 'ReadVariableNames', false); %read in data file
Original excel file:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/284580/image.jpeg)
How the data looks in matlab:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/284581/image.jpeg)
댓글 수: 5
Walter Roberson
2020년 4월 15일
The numbers are fractions of a day, so you can
Time = days(FractionsOfADay);
Time.Format = 'hh:mm:ss';
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!