correct NaT in time series - datetime function
6 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Martina Raffellini
il 5 Feb 2018
Risposto: Walter Roberson
il 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 Commenti
Risposta accettata
Walter Roberson
il 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 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!