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

% 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 日

1 投票

datestr uses MM to indicate minutes, you're indicating months above.
datestr(datenum('13:55:20','hh:MM:ss'),'hh:MM:ss')

その他の回答 (0 件)

カテゴリ

ヘルプ センター および 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