correct NaT in time series - datetime function
6 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Walter Roberson
2018-2-5
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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!