Transform from excel HH:MM:SS data to Matlab

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!

[Arvind Sathyanarayanan]

Have you tried this?

https://www.mathworks.com/matlabcentral/answers/26605-converting-hh-mm-ss-into-seconds

[madhan ravi]

Which version of matlab are you using? attach your excel file

[Silvio Risse]

The latest Version.

Answer 1

[madhan ravi]

Use readtable() to read the file.

Answer 2

[Silvio Risse]

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 !