Ingesting fractional second timestamps

Question

Tim 2015-7-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/229107-ingesting-fractional-second-timestamps

评论： Tim 2015-7-8

Hello,

I am using the activex interface to excel to draw timestamp data from a file. The column I am drawing in is formatted as time I believe but it has an extra amount of precision. for instance the dates are of the form:

12:34:56.789

However MATLAB ingests this as a 4 digit decimal number like 0.5678 which when converted back to the time stamp later, throws away the fractional second precision. Any ideas on how to fix this? I need to match message timing with another files of the same form.

Here is my code:

   dat_range = ['A25:A25000']; % Read to the last row overshoot
              rngObj = exlSheet1.Range(dat_range);
              exlData = rngObj.Value;
              B = exlData;
              clear exlData;
              B(isempy(B))=[];
              a.(platform).linkData.t = B;
              lastrow = length(B);
              clear B;

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

请先登录，再进行评论。

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

Answer 1

dpb 2015-7-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/229107-ingesting-fractional-second-timestamps#answer_185465

在 MATLAB Online 中打开

I think you're mistaking the happenstance of the value with the formatting--Matlab will import the full precision of the value as stored in Excel even though it won't display the additional precision by default. Using your values above as example (don't have your actual spreadsheet so can't demonstrate from it)

>> datenum('12:34:56.789')
ans =
 7.3597e+05
>> datestr(ans)
ans =
01-Jan-2015 12:34:56
>> datestr(datenum('12:34:56.789'),'HH:MM:SS.fff')
ans =
12:34:56.789
>>