converting Excel serial number of "Time" to hh:mm:ss format
3 ビュー (過去 30 日間)
古いコメントを表示
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);
0 件のコメント
採用された回答
その他の回答 (1 件)
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
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!