converting Excel serial number of "Time" to hh:mm:ss format
3 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
More Answers (1)
Walter Roberson
on 21 Jan 2011
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 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!