Asked by N =B>=>2
on 25 Apr 2013

I am importing data from Excel and one of the columns is with time stamps in the format 09:00:15 etc. I import it with XLS read, then I use datestr in order to convert the numbers in decimals Matlab gives me into proper time values. Then the resulting variable is char and I cannot use it, since I need it to be double. str2double does not do the job for me, it gives me NaN or Inf. Any suggestions?

*No products are associated with this question.*

Answer by per isakson
on 25 Apr 2013

Edited by per isakson
on 25 Apr 2013

*then I use datestr in order to convert the numbers in decimals Matlab gives me into proper time values*

does that mean something like

str = datestr( numbers, 'HH:MM:SS' );

then you need

num = datenum( str, 'HH:MM:SS' );

no I don't understand what you do. Why do you use datestr?

N =B>=>2
on 25 Apr 2013

My timedate in Excel looks like 09:04:23. When I import it in Matlab, it looks like 40148. It is in a matrix with some other columns also. Then I use datestr:

Time = datestr(whatever, 'HH:MM:SS')

After this the data looks like 09:00:23, but it is char, and I cannot use it in my matrix with the other info, it has to be double. And this is where my problem is, I cannot convert char into double

per isakson
on 25 Apr 2013

I think "40148" is the number of days since 1900-01-01 or 1899-12-31

>> datestr( (40148+datenum( 1900, 1, 1 )), 'yyyy-mm-dd HH:MM:SS' ) ans = 2009-12-03 00:00:00

The time information is lost? *some other columns also* is that there the time information hides?

See: http://www.mathworks.se/help/matlab/import_export/when-to-convert-dates-from-excel-files.html

Excel help says:

The integer portion of the number, ddddd, represents the number of days since 1900-Jan-0. For example, the date 19-Jan-2000 is stored as 36,544, since 36,544 days have passed since 1900-Jan-0. The number 1 represents 1900-Jan-1. It should be noted that the number 0 does not represent 1899-Dec-31. It does not. If you use the MONTH function with the date 0, it will return January, not December. Moreover, the YEAR function will return 1900, not 1899.

Related Content

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn moreOpportunities for recent engineering grads.

Apply Today
## 0 Comments