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?

Answer 1

[Star Strider]

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

.

[Shahar ben ezra]

Thanks!

What is the 1 used for? (iin MATLAB_Val = rem(datenum(Excel_Val, 'HH:MM:SS'),1)

If I have a vector of times does it matter??

[Star Strider]

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

.