read time in HH:mm format from excel

3 次查看（过去 30 天）

Sidharth Sanjeev Wazir 2023-8-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2009902-read-time-in-hh-mm-format-from-excel

回答： Walter Roberson 2023-8-18

I have to read a column from excel file named Time ,the data in that column is in HH:mm format i need to read it and save it and display it in same format

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson 2023-8-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2009902-read-time-in-hh-mm-format-from-excel#answer_1289147

在 MATLAB Online 中打开

filename = 'AppropriateFileName.xlsx';
opts = detectImportOptions(filename);
opts = setvaropts(opts, {'Time'}, 'Type', 'duration', 'InputFormat', 'hh:mm', 'DurationFormat', 'hh:mm');
T = readtable(filename, opts);