converting Excel serial number of "Time" to hh:mm:ss format

1 次查看（过去 30 天）
Ali Y.
Ali Y. 2011-1-21
I have a problem with "time" data type, so that, I import time data from Excel to MATLAB, and it just give the Excel serial number. could you please help me to convert it to hh:mm:ss format or as string.
.
I use Matlab 2008.
.
The code is like this:
.
[num text]=xlsread('...');
time=num(:,i);

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

采纳的回答

Doug Hull
Doug Hull 2011-1-21
>> now
ans =
7.3452e+005
>> datestr(now)
ans =
21-Jan-2011 14:50:52

更多回答（1 个）

Walter Roberson
Walter Roberson 2011-1-21
If the date is after Feb 28 1900, it appears that you will need to subtract 1 from the excel serial date to get to the serial date that matlab uses. Excel thinks that Feb 29 1900 existed, but it did not; this was apparently a deliberate design feature for compatibility with other products. Excel date description

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by