convert time stamp into minutes or seconds

4 次查看(过去 30 天)
I have a file with
29.06.2014 09:53:37 -1.8
29.06.2014 09:58:36 -2.0
29.06.2014 10:39:01 -2.0
I would like to covert the second column into how long time past from the first readout in the column, in minutes or seconds and plot column 2 and 3. Matlab doesn't seem to be able to handle the ':' sign. How do I do this?
Many thanks!

回答(2 个)

Jos (10584)
Jos (10584) 2014-7-1
I assume the 3rd column represents a value.
[D,T,V] = textread('MyFile.txt','%s%s%f')
DT = datevec(strcat(D,'-',T),'dd.mm.yyyy-HH:MM:ss') % convert to matlab time vectors
dTsec = arrayfun(@(k) etime(DT(k,:),DT(1,:)),1:size(DT,1)) % relative time in seconds

David Sanchez
David Sanchez 2014-7-1
Take a look at this thread, it deals right with your problem.

类别

Help CenterFile Exchange 中查找有关 MATLAB 的更多信息

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by