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

2 visualizzazioni (ultimi 30 giorni)
Kurt Feigl
Kurt Feigl il 30 Lug 2015
Commentato: Kurt Feigl il 30 Lug 2015
% 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

Accedi per rispondere a questa domanda.

Risposta accettata

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

Più risposte (0)

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Tag

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by