Reading a time column
显示 更早的评论
Hello
I have a CSV file, with columns of times
When I read the file by readmatrix or readcell or readtable
I get columns of values rather than times
How can I fix the problem?
采纳的回答
Here is one approach —
Excel_Val = '16:50:13' % Original
MATLAB_Val = rem(datenum(Excel_Val, 'HH:MM:SS'),1) % Fraction-Of-Day Representration
dt = datetime(MATLAB_Val, 'ConvertFrom','datenum', 'Format','HH:mm:ss') % ‘datetime’ Conversion
.
2 个评论
Shahar ben ezra
2021-5-2
As always, my pleasure!
The 1 in the rem call isolates the decimal fraction part of the floating-point argument to it.
For example —
arg = pi
decfrax_arg = rem(arg,1)
.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Holidays / Seasons 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
