清空筛选条件
清空筛选条件

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 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by