Time messed up after import from xls

Question

Shi Shu 2013-8-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84850-time-messed-up-after-import-from-xls

In an excel file, I have a column of time data as

00:00 AM
00:01 AM
00:02 AM
00:03 AM
00:04 AM
00:05 AM

when I import this column to Matlab, the data look like:

0
15740740740741e-05
31481481481481e-05
47222222222222e-05
62962962962963e-05
78703703703704e-05

and when i use the datastr to convert, the results look like this:

Where does the additional 1 minute come from?? I suspect it's about the accuracy of the numbers. Not sure though.

Please help. Thanks!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Azzi Abdelmalek 2013-8-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84850-time-messed-up-after-import-from-xls#answer_94400

在 MATLAB Online 中打开

d=[0
15740740740741e-05
31481481481481e-05
47222222222222e-05
62962962962963e-05
78703703703704e-05]
datestr(d,'HH:MM:SS')

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Shi Shu 2013-8-15

编辑：Azzi Abdelmalek 2013-8-15

在 MATLAB Online 中打开

Thanks, Azzi. I think this helped me out. Please try this code and you will see something interesting. I didn't expect the case of the letters can make this different.

d=[0;
15740740740741e-05;
31481481481481e-05;
47222222222222e-05;
62962962962963e-05;
78703703703704e-05];
datestr(d,'hh:mm:ss')

请先登录，再进行评论。

Answer 2

Jan 2013-8-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84850-time-messed-up-after-import-from-xls#answer_94401

Excel stores date as serial date numbers, which are not identical to Matlab's serial date format. See http://www.mathworks.com/matlabcentral/answers/64198#answer_75809 for an answer.