MATLAB: Get time from excel to matlab

excel

i have a column in my excel sheet as
6:25:48
6:28:18
6:30:20
6:32:37
6:35:40
but when i read that excel sheet to matlab, i get a
0.267916666666667
0.269652777777778
0.271064814814815
0.272650462962963
0.274768518518519

Best Answer

What's wrong with the serial time number?
d = [0.267916666666667; ...
     0.269652777777778; ...
     0.271064814814815; ...
     0.272650462962963; ...
     0.274768518518519];
datestr(d, 'HH:MM')   % Or HH:MM:SS
Related Question