How to do calculation on time values imported from Excel?

Hello,

I have the following values in Excel:

• Bed time 19:34:00
• Get up time 07:04:00
• Time in bed 11:30:00
• Sleep start 19:42:00
• Sleep end 07:00:00

I want to import them into MATLAB and do some calculation on these time values such as subtraction. The time values look like this after importing:

• 0.8153
• 0.2944
• 0.4792
• 0.8208
• 0.2917

and obviously doing calculation on them would be nonsense. Would any body help me with this issue? I have stuck with it for few days, and no progress yet.

Thanks in advance,

Answer 1

[Azzi Abdelmalek]

If a is your array

a=[0.8153 ,0.2944,0.4792,0.8208,0.2917]
out=datestr(a,'HH:MM:SS')

[Yoolla]

Dear Azzi,

Thanks for the answer,

But the output is in char format, which I cannot convert it to number. How can I subtract out(1,:) from out(3,:) and have the answer in time format?