converting times from excel file using datetime, datestr, and datenum

3 次查看（过去 30 天）
Kurt Feigl
Kurt Feigl 2015-7-30
评论： Kurt Feigl 2015-7-30
% I started using the following line to convert a time tag from excel to matlab jMatlabDateNum = datetime(S.DateTimePST,'ConvertFrom','excel');
% as suggested in the help page for DATETIME % datetime
% But the following line
datestr(datenum('13:55:20','hh:mm:ss'),'hh:mm:ss')
% gives output that I do not understand
13:07:20

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

采纳的回答

Sean de Wolski
Sean de Wolski 2015-7-30
datestr uses MM to indicate minutes, you're indicating months above.
datestr(datenum('13:55:20','hh:MM:ss'),'hh:MM:ss')

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by