Transforming Timestamps column into various columns

Hi all,

I'm with a problem and can't find the solution for it, hope you can help me.

I have this column;

Timestamps

01/01/2012 09:00

01/01/2012 10:00

01/01/2012 11:00

and now I want to slip it into 4 different columns with:

Day Month Year Hour

01 01 2012 9

The file is in excel.

Thanks.

Answer 1

[Andrei Bobrov]

data = {'01/01/2012 09:00'
'01/01/2012 10:00'
'01/01/2012 11:00'};

v = datevec(data);
out = v(:,1:4);

[João]

Thx, that's exactly what I was looking for.