Import hours from a excel file
1 view (last 30 days)
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.
per isakson on 22 Dec 2020
Edited: per isakson on 22 Dec 2020
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 )
I flipped the columns by mistake, because I'm used to date-time first.