Import hours from a excel file

3 次查看（过去 30 天）
stelios loizidis
stelios loizidis 2020-12-22
编辑： per isakson 2020-12-22
Hello, in a excel file I have 24 values in the first column and in the second column I have the corresponding hours (format of hours: 00:00:00, 01:00:00, .... 22:00:00, 23:00:00). The problem I have is that I can not insert the column with the hours in the code so I can draw the graph for the 24 values with the corresponding time. How is this done? Your help is invaluable.

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

回答（1 个）

per isakson
per isakson 2020-12-22
编辑：per isakson 2020-12-22
It can be done with https://se.mathworks.com/help/matlab/ref/duration.html. , but that requires more reading of the documentation. IMO: This simpler
T = readtable('stelios.xlsx');
h = 24*T.time % Obviously, T.time is in days
plot( h, T.data )
where stelios.xlsx
I flipped the columns by mistake, because I'm used to date-time first.

类别

在 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