converting Excel serial number of "Time" to hh:mm:ss format
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuesta aceptada
Doug Hull
el 21 de En. de 2011
>> now
ans =
7.3452e+005
>> datestr(now)
ans =
21-Jan-2011 14:50:52
0 comentarios
Más respuestas (1)
Walter Roberson
el 21 de En. de 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 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!