How to import date time format from excel?

I am trying to import excel data that has a date and time stamp, but MATLAB is ignoring it. The date and time is in the A column of excel, and when I use the import data button in MATLAB it only imports the data in the B column. In the excel cell it looks like this:

2016/03/11 15:50:47.689

But the actual data in the cell is:

3/11/2016 3:50:48 PM

This also doesn't make sense because in a slightly different file with the same date format is working.

Answer 1

[Azzi Abdelmalek]

Use xlsread function

[num,text,both]=xlsread('yourfile.xlsx')

[Evan Chou]

Thank you! That has worked.

[Peter Perkins]

In recent versions of MATLAB, you are better off using readtable rather than xlsread.

Answer 2

[mantu babu]

I also have problem like this and when is use " * _Use xlsread function

[num,text,both]=xlsread('yourfile.xlsx')_** "

function i get the time and date stamp but with 1 day delay. please help