Excel data to matlab

I have excel sheet with 2 column,time and amplitude.But ,time values are in 13:25:55 format.but i couldn't import this data to matlab. error message"note that matlab numeric array can not contain strings".how to import this tipe of data to matlab.(This are GPS signal data.I want to create a signal)

13:06:35  -1.777
13:06:40  -1.934
13:06:45  -1.855
13:06:50  -1.855
13:06:55  -1.914
13:07:00  -1.855
13:07:05  -1.797
13:07:10  -1.719
13:07:15  -1.797
13:07:20  -1.699
13:07:25  -1.543
13:07:30  -1.602
13:07:35  -1.582
13:07:40  -1.68
13:07:45  -1.68
13:07:50  -1.738
13:07:55  -1.68

[Image Analyst]

Is this the same as your other posting: http://www.mathworks.com/matlabcentral/answers/87321#answer_96862?

Answer 1

[Azzi Abdelmalek]

[v,T,vT] = xlsread('filename1.xlsx')   
temps=cell2mat(vT(:,1))  % time 
temps=datestr(temps,'HH:MM:SS')
valeur=cell2mat(vT(:,2))  % your value

[mahesh chathuranga]

Thanks Mr.Azzi.your the man

[George Wood]

Thanks Mr. Azzi. I really appreciate your answer, very helpful.

Answer 2

[David Sanchez]

Import your data as string using the sintax:

[num,txt] = xlsread(filename,sheet,range)

Once in Matlab, you can change the string to number.

Example:

x='10:23:34';
hour = str2num(x(1:2))
minute = str2num(x(4:5))
second = str2num(x(7:8))

Apply the code above to your needs