Import hours from a excel file
3 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
Mario Malic
2020 年 12 月 22 日
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
回答 (1 件)
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.
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!