MATLAB Answers

0

correct NaT in time series - datetime function

Asked by Martina Raffellini on 5 Feb 2018
Latest activity Answered by Walter Roberson
on 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 Comments

Sign in to comment.

1 Answer

Answer by Walter Roberson
on 5 Feb 2018
 Accepted Answer

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 Comments

Sign in to comment.