MATLAB Answers

Reading a time column

5 views (last 30 days)
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?

Accepted Answer

Star Strider
Star Strider on 2 May 2021
Here is one approach —
Excel_Val = '16:50:13' % Original
Excel_Val = '16:50:13'
MATLAB_Val = rem(datenum(Excel_Val, 'HH:MM:SS'),1) % Fraction-Of-Day Representration
MATLAB_Val = 0.7015
dt = datetime(MATLAB_Val, 'ConvertFrom','datenum', 'Format','HH:mm:ss') % ‘datetime’ Conversion
dt = datetime
16:50:13
.
  2 Comments
Star Strider
Star Strider on 2 May 2021
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
arg = 3.1416
decfrax_arg = rem(arg,1)
decfrax_arg = 0.1416
.

Sign in to comment.

More Answers (0)

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by