MATLAB: Time messed up after import from xls

convertdata formatdatestrexcelimporting excel dataMATLABtime value

In an excel file, I have a column of time data as
12:00:00 AM
12:00:01 AM
12:00:02 AM
12:00:03 AM
12:00:04 AM
12:00:05 AM
when I import this column to Matlab, the data look like:
0
1.15740740740741e-05
2.31481481481481e-05
3.47222222222222e-05
4.62962962962963e-05
5.78703703703704e-05
and when i use the datastr to convert, the results look like this:
00:01:00
00:01:01
00:01:02
00:01:03
00:01:04
00:01:05
Where does the additional 1 minute come from?? I suspect it's about the accuracy of the numbers. Not sure though.
Please help. Thanks!

Best Answer

d=[0
1.15740740740741e-05
2.31481481481481e-05
3.47222222222222e-05
4.62962962962963e-05
5.78703703703704e-05]
datestr(d,'HH:MM:SS')
Related Question