change time format to seconds
1 回表示 (過去 30 日間)
古いコメントを表示
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?
0 件のコメント
回答 (1 件)
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
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Data Type Conversion についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!