Converting time to a epoch
11 次查看(过去 30 天)
显示 更早的评论
When I have time data of a colum (Excel file) and each column has a data like "15:20:20" which means 3 something p.m.
So, there is only time information but not data. Suppose that the column is 100-by-1.
How can I convert it to time epoch such as a single number.
0 个评论
回答(1 个)
Cris LaPierre
2021-9-24
编辑:Cris LaPierre
2021-9-25
In MATLAB, you can read this in as a duration (see options here) using readtable. It may autodetect the time correctly. If not, you can manually specify it using code similar to this:
opts = detectImportOptions("filename.xlsx");
opts = setvartype(opts,1,'duration');
opts = setvaropts(opts,1,'InputFormat','hh:mm:ss');
data = readtable("filename.xlsx",opts)
Once imported, you can modify the format as you like. You can also use the following functions to represent the duration in a single unit of time like days, hours, minutes, and seconds
另请参阅
类别
在 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!