change time format to seconds

i have an excel file which i cant share

i am getting time array (char cells) in this format

00:00:00/00

.

.

.

01:36:45/345

"HH:MM:SS/sampling rate"

when i extract data from my excel file

i want to convert every cell of time array in to seconds

can any body help?

Answer 1

[Walter Roberson]

regexprep(YourCell, '/.*$','')

If you have a recent enough matlab then duration() can convert the character vectors. With older matlab you would want to split into components and convert them into numeric and duration() those; or you could datetime() and then subtract off the beginning of the day to convert to duration