Import dates from an excel spreadsheet

Hello,

I need to import the attached data from an excel spreadsheet into matlab.

Column E represents the temperature values and column F represents the time values.

When I import the time values in excel with the Import Tool the result is decimal numbers.

Other pots I have read about explain how to convert a single entry into the correct time value but my question is how do I convert the whole time column into the desired values in format HH:MM:SS.

Many thanks.

Answer 1

[Guillaume]

One way to read that data:

opts = detectImportOptions('temperature.xlsx');    %ask matlab to detect the format of the file
opts.VariableTypes{2} = 'duration';                %override format of Time to duraiton
opts = setvaropts(opts, 'Time', 'DurationFormat', 'hh:mm:ss')   %display duration as hh:mm:ss

tt = readtimetable('temperature.xlsx', opts)

Excel must do some rounding on the time that matlab doesn't do as some times are off by one second