0 voti

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?

Accedi per rispondere a questa domanda.

 Risposta accettata

Star Strider
Star Strider il 2 Mag 2021
Ran in:

0 voti

Ran in:
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 Commenti
Mostra Nessuno Nascondi Nessuno

Shahar ben ezra
Shahar ben ezra il 2 Mag 2021
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
Star Strider il 2 Mag 2021
Ran in:
Ran in:
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
.

Accedi per commentare.

Più risposte (0)

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by