How can I find the time difference between each consecutive rows?

12 次查看（过去 30 天）

Ammy 2018-7-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/408493-how-can-i-find-the-time-difference-between-each-consecutive-rows

回答： M.Devaki Mohanarangam 2023-9-8

I have a column in which date and time is mentioned, I want to find the time difference between every consective rows . Also how can I find the time difference in seconds , minutes, hours , days , weeks , months and years.

TimeStamp ; TimeDiff;

2014-09-02 07:48:09.567; NULL;

2014-09-02 07:51:02.810 ; 00:03:00

2014-09-02 08:06:13.387 ; 00:15:00

2014-09-02 08:37:09.647; 00:31:00

2014-09-02 14:32:00.113 ; 05:55:00

2014-09-02 16:16:42.593; 01:44:00

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Stephen23 2018-7-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/408493-how-can-i-find-the-time-difference-between-each-consecutive-rows#answer_327234

编辑：Stephen23 2018-7-3

Convert to datetime. The use caldiff (or diff).

8 个评论
显示 6更早的评论隐藏 6更早的评论

Ammy 2018-7-3

Thank you very much. But please If I want the time difference interval in only seconds or minutes then is there any way ?

Stephen23 2018-7-3

编辑：Stephen23 2018-7-3

在 MATLAB Online 中打开

@Noor Bano: yes, you can easily calculate this yourself. Serial date numbers (e.g. the output from datenum) are given in days, so...

Multiply the days by 24 to get hours (there are 24 hours in 1 day).
Multiply again by 60 to get minutes (there are 60 minutes in 1 hour).
Multiply again by 60 to get seconds (there are 60 seconds in 1 minute).

For example, to get the differences in minutes:

>> C = {'2014-09-02 07:48:09.567';'2014-09-02 07:51:02.810';'2014-09-02 08:06:13.387';'2014-09-02 08:37:09.647';'2014-09-02 14:32:00.113';'2014-09-02 16:16:42.593'};
>> N = datenum(C,'yyyy-mm-dd HH:MM:SS.FFF');
>> D = diff(N);
>> D*24*60
ans =
     2.8874
    15.1763
    30.9377
   354.8411
   104.7080