Time interval of a continuous record

1 次查看（过去 30 天）

Queena Edwards 2022-3-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1685524-time-interval-of-a-continuous-record

评论： Siddharth Bhutiya 2022-4-1

I would like to find the dureation between the following times. This is piece of a group of data called A.

The duration is one hour so it should display as:

NaN
01:00:00
01:00:00
01:00:00
01:00:00
NaN
01:00:00
01:00:00
NaN
01:00:00
NaN
01:00:00
01:00:00
01:00:00
NaN

3 个评论
显示 1更早的评论隐藏 1更早的评论

Queena Edwards 2022-3-31

yes it increases, as 00:00:00 is 00:00:00 "tomorrow" relative to 23:00:00 "today" . I have a column in my table showing the dates. The stuff I'm doing is a lil complex to explain so I chose to highlight what exactly i would like to focus on.

Siddharth Bhutiya 2022-4-1

在 MATLAB Online 中打开

You mentioned that this is just an example, so in your original data, what is the data type of these values? Are these stored as durations or datetimes? If you are storing these as durations then as Steven mentioned above you are using durations to represents datetimes with some implicit assumptions. This will always mean you would have to do more work to get the right behavior. On the other hand if these were datetimes, then this becomes a simple call to diff

d
d = 
  15×1 datetime array
   NaT                
   04-01-2022 22:00:00
   04-01-2022 23:00:00
   04-02-2022 00:00:00
   04-02-2022 01:00:00
   NaT                
   04-01-2022 16:00:00
   04-01-2022 17:00:00
   NaT                
   04-01-2022 06:00:00
   NaT                
   04-01-2022 14:00:00
   04-01-2022 15:00:00
   04-01-2022 16:00:00
   NaT                
diff(d)
ans = 
  14×1 duration array
        NaN
   01:00:00
   01:00:00
   01:00:00
        NaN
        NaN
   01:00:00
        NaN
        NaN
        NaN
        NaN
   01:00:00
   01:00:00
        NaN