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

4 ビュー (過去 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 ExchangeDates and Time についてさらに検索

製品

Community Treasure Hunt

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

Start Hunting!

Translated by