Readtable() turns time stamp into decimal
9 次查看(过去 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!