Import hours from a excel file
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentar
Mario Malic
am 22 Dez. 2020
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
Antworten (1)
per isakson
am 22 Dez. 2020
Bearbeitet: per isakson
am 22 Dez. 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 )
where stelios.xlsx
I flipped the columns by mistake, because I'm used to date-time first.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!