How to change an ecxel number to time and add to a plot

2 次查看（过去 30 天）
Teresa Phillips
Teresa Phillips 2016-8-16
评论： Walter Roberson 2016-8-17
I have imported an excel spreadsheet with a time variable (in excel the format is HH:MM:SS AM, but I would like it displayed as MM:SS) which when imported into matlab is shown as a number.
Currently, the data sits in a 130x22 table of which 'time' is :,1
I have used
TestTableTime = datestr(TestTable.Time, 'HH:MM:SS');
to convert the time which was effective except it now sits in a 130x68 char array. Is there a way in which I can change the values in my current table (named TestTable) or can the values be placed into a format in which I can use it as a variable for an x-axis on a plot?

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

回答（1 个）

Walter Roberson
Walter Roberson 2016-8-16
http://www.mathworks.com/help/matlab/import_export/when-to-convert-dates-from-excel-files.html
http://www.mathworks.com/help/matlab/ref/datetime.html#inputarg_dateType
If you have R2014b or later then you can use datetime objects as the x axis values.
If you are using R2014a or earlier you need to use serial date numbers together with datetick()
  2 个评论
Teresa Phillips
Teresa Phillips 2016-8-16
Sorry I am not exactly sure how to use this information to develop an x-axis
Walter Roberson
Walter Roberson 2016-8-17
TestTableTime = datetime(TestTable.Time, 'InputFormat', 'HH:MM:SS');
example_data = rand(size(TestTableTime));
plot(TestTableTime, example_data);

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by