Readtable() turns time stamp into decimal

7 次查看（过去 30 天）
Amanda Beatty
Amanda Beatty 2020-4-14
评论： Amanda Beatty 2020-4-15
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:
How the data looks in matlab:
  5 个评论
显示 3更早的评论
Walter Roberson
Walter Roberson 2020-4-15
The numbers are fractions of a day, so you can
Time = days(FractionsOfADay);
Time.Format = 'hh:mm:ss';
Amanda Beatty
Amanda Beatty 2020-4-15
Thank you both for helping me out!
Walter, that was exactly what I was trying to do. Thanks so much!

请先登录，再进行评论。

请先登录，再回答此问题。

回答（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!

Translated by