Reading a time column
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Shahar ben ezra
le 2 Mai 2021
Commenté : Star Strider
le 2 Mai 2021
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?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/604430/image.png)
0 commentaires
Réponse acceptée
Star Strider
le 2 Mai 2021
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 commentaires
Star Strider
le 2 Mai 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
decfrax_arg = rem(arg,1)
.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Text Files dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!