Importing data from excel, matlab is interpreting a time incorrectly
Show older comments
I'm working on analyzing a huge amount of machine generated data, and it was all generated with time set up in this format
hours: minutes
For example '05:03.2'
When importing the data matlab is interpreting it entirely incorrectly. For some reason all of the time values (which are all different) are coming in as 42763.04ish.
All I am using for this is the [num,txt,raw] = xlsread('filename.csv'). I have not done any other processing of the data except for trying to import it. Has anyone run into this issue before? Thanks
Answers (1)
dpb
on 4 May 2017
0 votes
They're read correctly, that's just the internal representation of how Excel stores dates that isn't consistent with Matlab.
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!