convert excel datetime to time in matlab

61 次查看（过去 30 天）
woongki park
woongki park 2018-9-30
评论： dpb 2018-10-1
in excel file C cell is datetime (2018-09-10 11:24:12 AM)
in matlab i only want to express 11:24:12
so i used a=datestr(xlsread(fileName,'C3:C30000'),'HH:MM:SS' ); but wrong time is shown 2018-09-10 11:50:27 AM -> 12:00:00 (like this)

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

回答（2 个）

dpb
dpb 2018-9-30
编辑：dpb 2018-9-30

Specific file always helps as Walter suggests, but try

 a=datetime(xlsread(fileName,'C3:C30000'),'convertfrom','excel');
 a.Format='HH.mm.ss';

xlsread imports Excel times as Excel time, not Matlab datenum -consistent so must convert to get into correct form for other Matlab functions such as datestr. But, datenum has been superceded by the datetime class so recommend using it instead.

  2 个评论
Walter Roberson
Walter Roberson 2018-9-30
There are multiple representations for times in Excel, with datetime() being appropriate for some of them but not for others.
dpb
dpb 2018-10-1
AFAIK, if they're actual internal dates inside Excel they're either base 1900 or 1904 and will be read as dates by xlsread that way. If they're actually text instead, then xlsread doesn't convert but readtable will if can.
I don't recall ever seeing any other behavior--what do you think is missing here, Walter?

请先登录，再进行评论。

Peter Perkins
Peter Perkins 2018-10-1
If possible, use readtable, not xlsread. It handles many of the vagueries of Excel timestamps, and in recent versionw will automatically convert Excel serial dates (formatted as dates) to datetimes.
At that point, once you have datetimes, you can through away the date portion using the timeofday function. You can make the date portion "disappear" by changing the format (as in dpb's suggestion, but that can be a bit dangerous -- for one thing, two timestamps that look identical may not be.
  1 个评论
dpb
dpb 2018-10-1
But timeofday is a duration, not a time and there can be "issues" in use of it, too, we've spoken of before.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by