清空筛选条件
清空筛选条件

Transform from excel HH:MM:SS data to Matlab

1 次查看（过去 30 天）
Silvio Risse
Silvio Risse 2019-1-28
回答： Silvio Risse 2019-1-28
Hello,
i want to transform a timestamp excel data which looks like HH:MM:SS to Matlab.
After it, the data should be convert into seconds.
I looked after it in the internet and found this:
Data=xlsread('Data.xls');
out=datestr(:,1),'HH:MM:SS');
After this code my data is a (column x 8) char vector.
8 because of HH:MM:SS. But it is useless for me. So is there any way to transform it, like i said, to seconds?
Thank you very much!
  3 个评论
显示 1更早的评论
madhan ravi
madhan ravi 2019-1-28
编辑：madhan ravi 2019-1-28
Which version of matlab are you using? attach your excel file

请先登录，再进行评论。

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

回答（2 个）

madhan ravi
madhan ravi 2019-1-28
Use readtable() to read the file.
Silvio Risse
Silvio Risse 2019-1-28
datenum( '14:35:59.812', 'HH:MM:SS' ) .* (24*60*60) - datenum( '00:00:00', 'HH:MM:SS' ) .* (24*60*60)
Is a good choice for my problem.
Thank you !

类别

在 Help Center 和 File Exchange 中查找有关 Time Series Objects 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by