Importing data from excel, matlab is interpreting a time incorrectly

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

回答(1 个)

They're read correctly, that's just the internal representation of how Excel stores dates that isn't consistent with Matlab.

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

回答:

dpb
2017-5-4

Community Treasure Hunt

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

Start Hunting!

Translated by