converting Excel serial number of "Time" to hh:mm:ss format
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Doug Hull
le 21 Jan 2011
>> now
ans =
7.3452e+005
>> datestr(now)
ans =
21-Jan-2011 14:50:52
0 commentaires
Plus de réponses (1)
Walter Roberson
le 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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!