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

Answers (1)

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

Categories

Asked:

on 4 May 2017

Answered:

dpb
on 4 May 2017

Community Treasure Hunt

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

Start Hunting!