Import hours from a excel file

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.

[Mario Malic]

Hey,

Try using importtool and import your time data as datetime type. See here for more https://www.mathworks.com/help/matlab/matlab_prog/plot-dates-and-durations.html

Answer 1

[per isakson]

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.