Transform from excel HH:MM:SS data to Matlab
1 view (last 30 days)
Show older comments
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 Comments
madhan ravi
on 28 Jan 2019
Edited: madhan ravi
on 28 Jan 2019
Which version of matlab are you using? attach your excel file
Answers (2)
See Also
Categories
Find more on Time Series Objects in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!