extract seconds from timestamp in cell

In cell column 1 I have this timestamp. 2011-04-19T01:01:59.000Z I want to put in column 2 the time in seconds. So this is 1 hour, 1 minute and 59 seconds so I want column 2 to be 3719 seconds.

How do I deal with only extracting the time?

Answer 1

[Kye Taylor]

I assume that the timestamp is represented as a string like:

C{1} = '2011-04-19T01:01:59.000Z';

Then, try

timeStamp = regexp(C{1},'\d*:\d*:\d*','match');
v = datevec(timeStamp);
C{2} = v(end-2:end)*[3600;60;1];

[Tiffany Lee]

thanks!

Answer 2

[Matt Fig]

Say your cell array looks like:

T = {'2011-04-19T01:01:59.000Z';...
     '2011-05-19T01:21:02.000Z';...
     '2011-06-19T21:11:51.000Z'}
% Now fill second column with seconds
STR = '${num2str(str2num($2)*3600+str2num($3)*60+str2num($4))}';
T(:,2) = regexprep(T,'(.*T)(\d+):(\d+):(\d+)(.*)',STR)

[Tiffany Lee]

thanks!