how to read date time column in matlab

My excel file contains datetime column in the format Sun Mar 5,16:06:17.66 How do I read the column along with the other numeric columns using xlsread. Attached in the snapshot of data.Unable to read Time column with xlsread

Answer 1

[Peter Perkins]

Unless you're using a version of MATLAB older than about R2015a, use readtable, not xlsread. In recent versions, you'll get a datetime variable in the table automatically. In less recent versions, you'll get either a numeric (Excel serial date numbers) or a text variable in the table, depending on how the cells in the spreadsheet are formatted. In either case, call datetime on that table variable to get a datetime variable. For Excel date numbers, use 'ConvertFrom','excel'.

[preeti visweswaran]

I am using an older version ,so cant use readtable.However,i will try the alternative and come back!

[preeti visweswaran]

I get the error "Attempt to reference field of non-structure array."

[Peter Perkins]

preeti, you will need to be more specific.