MATLAB: I have problem with detevec.

datadetevecimporting excel dataMATLABxlsread

Hi,

I want to read a='7/17/10 20:36' from excel to MATLAB.

b=datevec(a,'mm/dd/yy HH:MM');

I did that but I ended up having '7/17/2010 8:36:00 PM' but I want to have '7/17/2010 20:36'.

any help please?

You used datevec() which returns numeric contents not strings.

>> datevec(a,'mm/dd/yy HH:MM')
ans =
        2010           7          17          20          36           0

You must have used datestr() to get the string; in that case use the format that you want

>> datestr(datevec(a,'mm/dd/yy HH:MM'), 'mm/dd/yy HH:MM')
ans =
07/17/10 20:36

>> now
ans =
    7.3452e+005
>> datestr(now)
ans =
21-Jan-2011 14:50:52

See if this does what you want:

DateTime = {'1-12-13 21:34' '1-12-13 21:35' '1-12-13 21:36'};
NewDate = datestr(datenum(DateTime, 'dd-mm-yy HH:MM'), 'dd-mm-yy HH:MM')

produces:

NewDate =
01-12-13 21:34
01-12-13 21:35
01-12-13 21:36