How to do calculation on time values imported from Excel?

2016 3 22
1 个回答
更新时间：2016 3 22
2 次查看（30 天）

0 个投票

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,

请先登录，再回答此问题。

回答（1 个）

Azzi Abdelmalek
Azzi Abdelmalek 2016-3-22
编辑：Azzi Abdelmalek 2016-3-22

0 个投票

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

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Yoolla
Yoolla 2016-3-22
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?

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

提问:

Yoolla
Yoolla
2016-3-22

评论：

Yoolla
Yoolla
2016-3-22

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by