change time format to seconds

3 次查看（过去 30 天）
asad ali
asad ali 2019-6-29
回答： Walter Roberson 2019-6-29
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?

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

回答（1 个）

Walter Roberson
Walter Roberson 2019-6-29
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

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by