converting Excel serial number of "Time" to hh:mm:ss format

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);

Answer 1

[Doug Hull]

>> now

ans =

    7.3452e+005
>> datestr(now)

ans =

21-Jan-2011 14:50:52

Answer 2

[Walter Roberson]

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