Spreadsheet: 45521d1244240782-counting-times-excel-forum-example-1-
Sheet: Example

Blank | Blank | alm_time | arv_time | Travel Time | Test
 |  | 14:49:00 | 14:49:00 |  | 52
 |  | 19:37:46 | 19:37:46 |  | 75
 |  | [NAME] | [NAME] |  | 16
 |  | 18:32:11 | 18:32:11 |  | 18
 |  | 20:52:31 | 20:52:31 |  | 9
 |  | 08:07:07 | 08:07:07 |  | 10
 |  | 05:14:20 | 05:14:20 |  | 15
 |  | 23:04:45 | 23:04:45 |  | 36
 |  | 19:34:01 | 19:34:01 |  | 18
 |  | 11:55:01 | 11:55:01 |  | 25
 |  | 18:10:20 | 18:10:20 |  | 22
 |  | 18:44:24 | 18:44:24 |  | 15
 |  | 13:28:36 | 13:28:36 |  | 4
 |  | 19:46:23 | 19:46:23 |  | 80
 |  | 12:16:15 | 12:16:15 |  | 34
 |  | 17:51:48 | 17:51:48 |  | 29
 |  | 22:46:07 | 22:46:07 |  | 3
 |  | 07:52:24 | 07:52:24 |  | 21
 |  | 12:29:17 | 12:29:17 |  | 32
 |  | 19:36:37 | 19:36:37 |  | 7
 |  | 10:40:16 | 10:40:16
 |  | 18:20:18 | 18:20:18
 |  | 22:31:36 | 22:31:36
 |  | 16:07:59 | 16:07:59
 |  | 09:48:41 | 09:48:41
 |  | 09:12:44 | 09:12:44
 |  | 06:28:47 | 06:28:47
 |  | 23:17:10 | 23:17:10
 |  | 20:25:11 | 20:25:11
 |  | 09:32:24 | 09:32:24
 |  | 09:21:40 | 09:21:40
 |  | 15:38:52 | 15:38:52
 |  | 00:46:31 | 00:46:31
 |  | 23:30:15 | 23:30:15
 |  | 23:42:25 | 23:42:25
 |  | 02:13:51 | 02:13:51
 |  | 20:27:22 | 20:27:22
 |  | 14:43:41 | 14:43:41
 |  | 10:48:57 | 10:48:57
 |  | 22:35:25 | 22:35:25
 |  | 21:19:33 | 21:19:33
 |  | 13:58:01 | 13:58:01
 |  | 10:00:59 | 10:00:59
 |  | 22:02:17 | 22:02:17
 |  | 21:09:39 | 21:09:39
 |  | 16:35:28 | 16:35:28
 |  | 15:27:00 | 15:27:00
 |  | 21:24:23 | 21:24:23
 |  | 14:52:32 | 14:52:32
 |  | 16:44:18 | 16:44:18
 |  | 02:44:50 | 02:44:50
 |  | 16:14:47 | 16:14:47
 |  | 17:12:37 | 17:12:37
 |  | 10:58:00 | 10:58:00
 |  | 11:32:27 | 11:32:27
 |  | 14:23:34 | 14:23:34
 |  | 21:39:59 | 21:39:59
 |  | 17:44:21 | 17:44:21
 |  | 22:09:36 | 22:09:36
 |  | 18:04:22 | 18:04:22
 |  | 13:08:53 | 13:08:53
 |  | 18:29:23 | 18:29:23
 |  | 09:30:06 | 09:30:06
 |  | 16:28:43 | 16:28:43
 |  | 15:24:24 | 15:24:24
 |  | 10:31:26 | 10:31:26
 |  | 11:06:01 | 11:06:01
 |  | 19:16:08 | 19:16:08
 |  | 17:31:02 | 17:31:02
 |  | 17:46:44 | 17:46:44
 |  | 16:55:42 | 16:55:42
 |  | 16:28:07 | 16:28:07
 |  | 14:48:51 | 14:48:51
 |  | 15:20:53 | 15:20:53
 |  | 13:51:34 | 13:51:34
 |  | 15:57:26 | 15:57:26
 |  | 01:07:17 | 01:07:17
 |  | 14:56:06 | 14:56:06
 |  | 20:54:45 | 20:54:45
 |  | 00:32:33 | 00:32:33
 |  | 00:50:19 | 00:50:19
 |  | 05:11:08 | 05:11:08
 |  | 18:22:39 | 18:22:39
 |  | [NAME] | [NAME]
 |  | 04:00:14 | 04:00:14
 |  | 13:08:21 | 13:08:21
 |  | 08:54:37 | 08:54:37
 |  | [NAME] | [NAME]
 |  | 04:13:28 | 04:13:28
 |  | 01:44:04 | 01:44:04
 |  | 20:52:24 | 20:52:24
 |  | 18:09:43 | 18:09:43
 |  | 19:19:10 | 19:19:10
 |  | 20:59:42 | 20:59:43
 |  | 13:24:11 | 13:24:12
 |  | 07:59:27 | 07:59:28
 |  | 07:46:38 | 07:46:39
 |  | 12:20:42 | 12:20:43
 |  | 14:35:57 | 14:35:58
 |  | 08:53:12 | 08:53:13
 |  | 11:54:48 | 11:54:49
 |  | 13:17:35 | 13:17:36
 |  | 08:09:31 | 08:09:32
 |  | 02:41:15 | 02:41:16
 |  | 01:45:39 | 01:45:40
 |  | 06:52:37 | 06:52:38
 |  | 04:40:57 | 04:40:58
 |  | 09:58:09 | 09:58:10
 |  | 07:12:41 | 07:12:42
 |  | 07:03:59 | [NAME]
 |  | [NAME] | 13:40:49
 |  | 16:02:44 | 16:02:45
 |  | 23:01:45 | 23:01:46
 |  | 21:41:25 | 21:41:26
 |  | 22:34:43 | 22:34:44
 |  | 14:56:56 | 14:56:57
 |  | 13:20:05 | 13:20:06
 |  | 18:31:17 | 18:31:19
 |  | 21:39:02 | 21:39:04
 |  | 21:45:09 | 21:45:11
 |  | 22:29:15 | 22:29:17
 |  | 15:59:58 | 16:00:00
 |  | 09:12:48 | [NAME]
 |  | [NAME] | 09:56:42
 |  | 18:38:45 | 18:38:47
 |  | 06:41:47 | 06:41:49
 |  | 10:43:18 | 10:43:20
 |  | 13:34:00 | 13:34:02
 |  | 20:12:38 | 20:12:40
 |  | 21:48:37 | 21:48:40
 |  | 18:18:21 | 18:18:24
 |  | 09:50:15 | 09:50:18
 |  | 09:44:19 | 09:44:22
 |  | 09:25:58 | 09:26:01
 |  | 08:01:45 | 08:01:48
 |  | 10:26:42 | 10:26:45
 |  | 00:39:34 | 00:39:37
 |  | 00:44:09 | 00:44:12
 |  | 13:53:15 | 13:53:18
 |  | 09:07:39 | 09:07:42
 |  | 09:55:39 | [NAME]
 |  | 11:38:47 | 11:38:50
 |  | 19:50:10 | 19:50:13
 |  | 14:00:11 | 14:00:14
 |  | 00:48:18 | 00:48:21
 |  | 15:09:38 | 15:09:41
 |  | 14:25:56 | 14:25:59
 |  | 07:45:54 | 07:45:57
 |  | [NAME] | 10:53:37
 |  | 09:04:32 | 09:04:35
 |  | 10:35:56 | 10:35:59
 |  | 16:36:54 | 16:36:57
 |  | 18:14:32 | 18:14:35
 |  | 16:40:20 | 16:40:23
 |  | 14:21:23 | 14:21:26
 |  | 17:00:59 | 17:01:03
 |  | 23:41:18 | 23:41:22
 |  | 09:47:30 | 09:47:34
 |  | 11:28:16 | 11:28:20
 |  | [NAME] | 09:00:21
 |  | 09:13:31 | [NAME]
 |  | 18:21:48 | 18:21:52
 |  | 22:17:05 | 22:17:09
 |  | 18:51:06 | 18:51:10
 |  | 18:07:32 | 18:07:36
 |  | 04:38:46 | [NAME]
 |  | 00:12:24 | 00:12:28
 |  | 20:47:16 | 20:47:20
 |  | 12:07:19 | 12:07:23
 |  | 21:15:14 | 21:15:18
 |  | 12:50:30 | 12:50:35
 |  | 22:34:55 | 22:35:00
 |  | 08:42:12 | 08:42:17
 |  | 10:05:09 | 10:05:14
 |  | 12:54:06 | 12:54:11
 |  | 22:04:26 | 22:04:31
 |  | 21:00:35 | 21:00:40
 |  | 20:25:39 | 20:25:44
 |  | 10:20:43 | 10:20:48
 |  | [NAME] | 10:19:47
 |  | 14:52:29 | 14:52:34
 |  | 22:28:45 | 22:28:51
 |  | 18:54:45 | 18:54:51
 |  | 20:36:14 | 20:36:20
 |  | 02:35:49 | 02:35:55
 |  | 14:54:59 | 14:55:05
 |  | 11:21:34 | 11:21:40
 |  | 10:13:02 | 10:13:08
 |  | 12:24:44 | 12:24:50
 |  | 12:02:41 | 12:02:47
 |  | 13:17:50 | 13:17:56
 |  | 13:48:49 | 13:48:55
 |  | 12:31:55 | 12:32:01
 |  | 15:05:07 | [NAME]
 |  | 18:31:57 | 18:32:03
 |  | 19:52:00 | 19:52:07
 |  | 13:59:35 | 13:59:42
 |  | 12:11:18 | 12:11:25
 |  | 20:55:52 | 20:55:59
 |  | 12:21:30 | 12:21:37
 |  | 16:44:06 | 16:44:13
 |  | 17:45:59 | 17:46:06
 |  | 00:09:20 | 00:09:27
 |  | 05:10:16 | 05:10:23
 |  | 12:05:39 | 12:05:46
 |  | 11:41:11 | 11:41:19
 |  | 08:08:02 | 08:08:10
 |  | 17:30:07 | 17:30:15
 |  | 07:44:36 | 07:44:44
 |  | 17:54:45 | 17:54:54
 |  | 18:18:12 | 18:18:21
 |  | 18:18:42 | 18:18:51
 |  | 07:44:02 | [NAME]
 |  | 08:23:28 | 08:23:37
 |  | 07:33:22 | 07:33:31
 |  | 03:50:01 | 03:50:10
 |  | 13:43:37 | 13:43:46
 |  | 19:27:16 | 19:27:25
 |  | 14:10:52 | 14:11:01
 |  | 20:39:55 | 20:40:05
 |  | 07:09:39 | 07:09:49
 |  | 15:59:28 | 15:59:38
 |  | 20:22:02 | 20:22:12
 |  | 23:10:01 | 23:10:11
 |  | 13:10:25 | 13:10:35
 |  | 19:01:00 | 19:01:10
 |  | 11:25:16 | 11:25:27
 |  | 23:36:53 | 23:37:04
 |  | 11:17:55 | 11:18:06
 |  | 18:45:07 | 18:45:18
 |  | 13:37:23 | 13:37:34
 |  | [NAME] | [NAME]
 |  | 12:37:16 | 12:37:27
 |  | 19:42:41 | 19:42:52
 |  | 07:49:23 | 07:49:34
 |  | 16:56:09 | 16:56:21
 |  | 11:14:54 | 11:15:06
 |  | 21:43:32 | 21:43:44
 |  | 16:36:11 | 16:36:23
 |  | 11:52:35 | 11:52:47
 |  | [NAME] | 13:44:50
 |  | 14:12:05 | 14:12:18
 |  | 18:21:30 | [NAME]
 |  | 09:18:06 | [NAME]
 |  | 13:13:54 | 13:14:08
 |  | 08:48:36 | 08:48:50
 |  | 18:12:31 | 18:12:45
 |  | 15:00:42 | 15:00:57
 |  | 12:31:26 | 12:31:41
 |  | 07:15:44 | 07:16:00
 |  | 10:33:50 | 10:34:06
 |  | 13:56:44 | 13:57:01
 |  | 11:16:12 | 11:16:29
 |  | 18:24:47 | 18:25:04
 |  | 14:50:43 | 14:51:00
 |  | 21:39:16 | 21:39:33
 |  | 19:33:56 | 19:34:13
 |  | 14:36:07 | 14:36:25
 |  | 10:33:17 | 10:33:35
 |  | 00:38:05 | 00:38:23
 |  | 09:37:58 | 09:38:16
 |  | 14:53:48 | 14:54:06
 |  | 16:54:40 | 16:54:58
 |  | 21:18:24 | 21:18:42
 |  | 10:47:36 | 10:47:55
 |  | 12:32:45 | 12:33:04
 |  | 09:27:11 | 09:27:30
 |  | 20:35:25 | 20:35:44
 |  | 21:37:59 | 21:38:18
 |  | [NAME] | 07:33:01
 |  | 01:23:28 | 01:23:47
 |  | 16:46:45 | 16:47:04
 |  | 15:23:45 | 15:24:05
 |  | 15:54:18 | 15:54:38
 |  | 15:09:11 | 15:09:31
 |  | 11:18:45 | 11:19:05
 |  | 11:53:34 | 11:53:54
 |  | 21:10:53 | 21:11:13
 |  | 12:17:52 | 12:18:13
 |  | 13:29:39 | 13:30:00
 |  | 12:12:58 | 12:13:20
 |  | 09:39:21 | [NAME]
 |  | 10:26:47 | 10:27:09
 |  | 19:58:50 | 19:59:12
 |  | 17:59:55 | 18:00:18
 |  | 13:50:28 | 13:50:51
 |  | 15:10:45 | 15:11:09
 |  | 13:11:54 | 13:12:18
 |  | 07:40:05 | 07:40:29
 |  | 21:31:39 | 21:32:03
 |  | 15:20:52 | 15:21:16
 |  | 10:54:28 | 10:54:52
 |  | 21:09:34 | 21:09:58
 |  | 20:49:12 | 20:49:37
 |  | 22:15:31 | 22:15:56
 |  | 08:04:04 | 08:04:29
 |  | 20:15:59 | 20:16:24
 |  | 14:12:46 | 14:13:11
 |  | 14:17:55 | 14:18:20
 |  | 12:56:19 | 12:56:44
 |  | 15:51:09 | [NAME]
 |  | 21:39:08 | 21:39:33
 |  | 19:10:21 | 19:10:46
 |  | 17:07:33 | 17:07:59
 |  | 15:29:38 | 15:30:04
 |  | 23:00:06 | 23:00:32
 |  | 20:50:59 | 20:51:26
 |  | 17:08:26 | 17:08:53
 |  | 16:57:04 | 16:57:31
 |  | 08:41:42 | 08:42:09
 |  | 11:46:08 | 11:46:35
 |  | 03:50:15 | 03:50:42
 |  | 11:34:48 | 11:35:15
 |  | 19:58:48 | 19:59:15
 |  | 14:36:23 | 14:36:51
 |  | 13:06:35 | 13:07:03
 |  | 10:56:14 | 10:56:42
 |  | 09:55:20 | 09:55:48
 |  | 20:27:53 | 20:28:21
 |  | 15:27:32 | 15:28:00
 |  | 18:35:57 | 18:36:25
 |  | 15:00:20 | 15:00:49
 |  | [NAME] | 09:51:55 |  |  | alm_time | alm_time |  | test | test
 |  | 13:43:42 | 13:44:11 |  |  | 00:00:00 | 00:59:00 |  | >=0 | <=15
 |  | 06:38:59 | [NAME] |  |  | alm_time | alm_time
 |  | 07:27:24 | 07:27:53 |  |  | 01:00:00 | 01:59:00
 |  | [NAME] | 21:55:46 |  |  | alm_time | alm_time
 |  | 10:08:49 | 10:09:19 |  |  | 02:00:00 | 02:59:00
 |  | 19:41:42 | 19:42:12
 |  | 11:04:22 | 11:04:52
 |  | [NAME] | 05:58:21
 |  | 17:20:27 | 17:20:57 |  |  | 12:00am |  | 1:00am |  | 2:00am
 |  | 19:04:12 | 19:04:42
 |  | 21:53:18 | 21:53:48
 |  | 20:27:17 | 20:27:48
 |  | 15:33:56 | 15:34:27 |  |  | test
 |  | [NAME] | 22:17:32
 |  | Average