Spreadsheet: 127178d1320207300-comparing-two-columns-of-time-using-conditional-formatting-in-excel-example
Sheet: Sheet1

Start Time | Start Time
22:38:40 | 22:38:40
22:41:24 | 22:41:28
22:49:39 | 22:37:15
22:50:41 | 22:38:43
22:55:41 | 22:40:45 |  | So the blue highlights are times that are exactly the same
22:57:11 | 22:51:31
22:58:34 | 22:55:42 |  | What I want to do is for example B4 occurs 4s after A4 (highlighted in RED)
23:01:44 | 22:56:47
23:09:51 | 22:58:31 |  | Therefore, I would like to highlight (in a different colour) times that occur within 5 seconds of each other
23:10:53 | 23:23:56 |  |  | And if possible, highlight for example RED for the time that occurs 1st and then again for example YELLOW for the time that occurs second within 5s)
23:16:56 | 22:38:40
22:58:31 | 23:25:28
23:46:44 | 23:26:02
00:01:43 | 23:26:45
00:05:36 | 23:27:54
00:08:36 | 23:29:28
23:30:21 | 23:30:21
00:10:21 | 23:30:42
00:26:13 | 23:32:16
00:26:30 | 23:36:12
00:32:28 | 23:36:38
23:30:21 | 23:43:19
00:56:33 | 23:43:58
00:56:49 | 23:46:58
00:58:44 | 23:50:25
00:59:43 | 23:51:27
01:05:20 | 00:01:23
01:12:58 | 00:05:39
01:15:42 | 00:12:25
01:16:19 | 00:20:16
01:19:36 | 00:22:09
01:33:46 | 00:26:05
01:34:27 | 00:26:27
01:44:32 | 00:29:59
01:44:51 | 00:34:29
01:45:37 | 00:57:06
01:49:02 | 00:57:29
01:22:51 | 00:58:47
01:50:44 | 01:06:56
01:52:08 | 01:08:55
01:52:23 | 01:10:18
01:52:48 | 01:11:43
01:53:56 | 01:14:31
01:54:35 | 01:19:57
01:57:48 | 01:22:51
02:01:00 | 01:40:22
02:04:06 | 01:45:32
02:05:03 | 01:45:57
02:06:00 | 01:48:42
02:07:04 | 01:48:56
02:07:30 | 01:49:24
02:08:21 | 01:50:21
02:15:45 | 01:52:46
02:16:45 | 01:55:19
02:17:25 | 01:59:52
02:24:06 | 02:07:24
02:24:45 | 02:07:56
02:29:40 | 02:08:21
02:31:44 | 02:15:37
02:35:31 | 02:16:42
02:35:57 | 02:17:22
02:41:04 | 02:19:29
02:44:21 | 02:22:16
02:45:51 | 02:23:53
02:51:44 | 02:27:02
02:54:26 | 02:29:03
02:56:18 | 02:33:08
03:18:10 | 02:33:28
03:18:33 | 02:34:00
03:22:36 | 02:34:28
03:23:41 | 02:35:32
03:24:20 | 02:41:03
03:25:08 | 02:41:39
03:26:48 | 02:43:59
03:27:21 | 02:55:21
03:28:10 | 02:57:43
03:28:28 | 02:58:11
03:29:14 | 03:00:16
03:29:31 | 03:00:43
03:30:51 | 03:05:52
03:31:12 | 03:27:20
03:34:33 | 03:28:25
03:40:18 | 03:33:58
03:43:24 | 03:36:38
03:47:50 | 03:37:01
03:48:53 | 03:38:26
03:52:49 | 03:38:49
03:53:38 | 03:40:17
03:56:38 | 03:40:34
03:57:30 | 03:40:53
03:58:16 | 03:42:27
04:03:30 | 03:47:43
04:04:09 | 03:48:57
04:04:59 | 03:50:25
04:05:33 | 03:56:40
04:07:58 | 04:00:54
04:08:51 | 04:03:38
04:09:20 | 04:04:12
04:11:58 | 04:04:32
04:13:18 | 04:04:59
04:17:00 | 04:08:10
04:18:32 | 04:09:48
04:19:12 | 04:17:55
04:22:16 | 04:22:12
04:29:02 | 04:28:51
04:29:42 | 04:31:20
04:30:34 | 04:48:30
04:31:07 | 04:56:11
04:34:31 | 05:00:18
04:37:49 | 05:00:44
04:38:20 | 05:01:30
04:39:09 | 05:04:00
04:46:08 | 05:05:19
04:47:53 | 05:12:17
04:50:34 | 05:13:42
04:54:49 | 05:14:04
04:55:28 | 05:14:30
04:59:20 | 05:16:31
04:59:53 | 05:19:52
05:00:54 | 05:20:08
05:01:09 | 05:22:03
05:02:18 | 05:22:24
05:03:13 | 05:22:41
05:03:52 | 05:26:51
05:07:49 | 05:32:22
05:10:59 | 05:38:28
05:14:12 | 05:42:35
05:20:14 | 05:45:53
05:20:37 | 05:46:54
05:22:42 | 05:47:15
05:22:53 | 05:49:09
05:25:50 | 05:52:46
05:29:45 | 05:59:18
05:35:57 | 06:03:50
05:37:00 | 06:04:06
05:37:29 | 06:04:25
05:37:54 | 06:04:39
05:42:26 | 06:08:56
05:44:18 | 06:09:41
05:45:18 | 06:09:57
05:59:21 | 06:10:57
06:09:05 | 06:11:44
06:12:38 | 06:12:36
06:13:30 | 06:13:19