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

2018 7 3
2 个回答
回答已采纳
更新时间：2023 9 8
21 次查看（30 天）

0 个投票

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

0 个投票

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

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

Stephen23
Stephen23 2018-7-3
编辑：Stephen23 2018-7-3
@Noor Bano: Please explain if these dates are in a file, a table, a cell array, or a char array. If they are in a file, write what kind of file, and how you are importing that data?
If those dates are in a file then you can import the dates as datetime: both textscan and readtable support this, if you have a new enough MATLAB version. What version of MATLAB are you using?
Stephen23
Stephen23 2018-7-3
Noor Bano's "Answer" moved here:
I am using 2013 a, and this data is in excel file , after importing the data I have a column vector in matlab , how can I find the time difference between each row and what is the format of date and time for finding the difference.
Stephen23
Stephen23 2018-7-3
"I am using 2013 a"
Aha, so you can't use datetime anyway. Good to know.
"after importing the data I have a column vector in matlab"
I presume that by "column vector" you have a cell array of char vectors.
Stephen23
Stephen23 2018-7-3
编辑：Stephen23 2018-7-3
You could convert to datenum, diff, and then convert to a string representation. Assuming that you have a cell array of char vectors C, something like this might work:
N = datenum(C,'yyyy-mm-dd HH:MM:SS');
D = diff(N);
datestr(D,'HH:MM:SS')
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 个）

0 个投票

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

类别

在 帮助中心 和 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