correct NaT in time series - datetime function
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Martina Raffellini
am 5 Feb. 2018
Beantwortet: Walter Roberson
am 5 Feb. 2018
Hello! I am using the datetime function for a rainfall time series imported from excel:
[a z] = xlsread('complete_series.xlsx',2,'D1:E135714');
t1 = datetime(z(:,1),'InputFormat','dd.MM.yyyy HH:mm:ss');
but each time at midnight i get NaT value.
For example in excel i have 08.09.2015 00:00:00, the datetime function returns NaT. All other values different from midnight are correct.
Where could my mistake be? Thank you
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 5 Feb. 2018
See https://www.mathworks.com/matlabcentral/answers/380537-date-format-changes-at-midnight#comment_531541 -- Excel is using a different date format for midnight exactly.
I would suggest, however, that you instead use readtable. You might need to use detectImportOptions first to fix up the format for the time objects, possibly.
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!