Finding time difference that meet criteria

1 次查看（过去 30 天）
ALDO
ALDO 2020-7-8
评论： ALDO 2020-8-1
Hi guys
I need to compare two columns of data with each other. They are all in time format 00:00:00. I need to group them groups of two which are 20 seconds apart from each other and put the ones meeting the criteria in separate column. it could be 20 seconds before or after each other.
As an example, these consider two columns A and B columns. for example, the first row meets the criteria because it has 2 seconds difference in time which is less than 20.
I would appreciate any help. Thanks in advance!
A B
05:49:13 05:49:15
05:52:41 05:52:42
08:39:43 09:20:44
09:35:52 09:35:52
09:58:14 09:58:27
10:00:11 10:00:02
10:16:48 10:16:41
12:20:08 12:20:08
12:37:41 12:37:53
12:41:09 12:40:54
12:46:20 12:46:32
12:48:18 12:48:19
  2 个评论
jonas
jonas 2020-7-8
identifying those pairs is trivial, but what exactly do you mean by putting them in separate columns? Could you just delete those which do not meet the criterion?
ALDO
ALDO 2020-7-8
Thank you for your comment. yes deleting them could also work. but I need both the ones that meet critera and the ones that dont. I am new to using datetime so I do not know how to compare them.

请先登录，再进行评论。

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

回答（1 个）

jonas
jonas 2020-7-8
First make sure your data is in duration format.
%making up some data
t1 = (hours(10):hours(2):hours(24))';
t2 = t1 + rand(numel(t1),1).*seconds(40);
t = [t1,t2];
t.Format = 'hh:mm:ss';
%find time difference less than 20 s
id = abs(t1-t2)<seconds(20);
% remove pairs not meeting criterion
t(~id,:) = []
  3 个评论
显示 1更早的评论
jonas
jonas 2020-7-9
Okay, better provide some real data then. Can there for example be multiple matches in B to one element in A?
ALDO
ALDO 2020-8-1
Hi! I appologize for the delay is my responce. Yes there could be multiple matches for B to one element in A. I will provide real data as soon as I have access to it! Thanks again!

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by