Effacer les filtres
Effacer les filtres

Readtable() turns time stamp into decimal

8 vues (au cours des 30 derniers jours)
Amanda Beatty
Amanda Beatty le 14 Avr 2020
Commenté : Amanda Beatty le 15 Avr 2020
I have a table with 40 columns. When I use readtable() it turns the time stamps into decimals and I don't know what the decimals mean. I need to extract the time stamps. And also I don't want the headers, but it reads them anyways.
data = readtable(filename, 'ReadVariableNames', false); %read in data file
Original excel file:
How the data looks in matlab:
  5 commentaires
Walter Roberson
Walter Roberson le 15 Avr 2020
The numbers are fractions of a day, so you can
Time = days(FractionsOfADay);
Time.Format = 'hh:mm:ss';
Amanda Beatty
Amanda Beatty le 15 Avr 2020
Thank you both for helping me out!
Walter, that was exactly what I was trying to do. Thanks so much!

Connectez-vous pour commenter.

Réponses (0)

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by