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

4 次查看（过去 30 天）
Ammy
Ammy 2018-7-3
回答： 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

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

采纳的回答

Stephen23
Stephen23 2018-7-3
编辑：Stephen23 2018-7-3
Convert to datetime. The use caldiff (or diff).
  8 个评论
显示 6更早的评论
Ammy
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
Stephen23 2018-7-3
编辑：Stephen23 2018-7-3
@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

请先登录，再进行评论。

更多回答（1 个）

M.Devaki Mohanarangam
Time = [16/04/2023 14:44:22
16/04/2023 14:44:26
16/04/2023 14:44:31
16/04/2023 14:44:36
16/04/2023 14:44:42
16/04/2023 14:44:46
16/04/2023 14:44:51
16/04/2023 14:44:56
16/04/2023 14:45:02
16/04/2023 14:45:06 ]
how to find time difference in loop condtion? plz help

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by