Spreadsheet: 66600d1267220259-count-frequency-of-set-hour-ranges-from-large-list-of-times-time_tbl_pivot
Sheet: times

scan_ts_RAW | DATE TIME | TIME
2009-02-01 00:00:49 | 2009-01-31 19:00:49 | 19:00:49
2009-02-01 00:00:55 | 2009-01-31 19:00:55 | 00:00:55
2009-02-01 00:01:05 | 2009-01-31 19:01:05 | 00:01:05 |  | Count of DATE TIME |  |  | Count of TIME
2009-02-01 00:01:21 | 2009-01-31 19:01:21 | 00:01:21 |  | DATE TIME | Total |  | TIME | Total
2009-02-01 00:01:30 | 2009-01-31 19:01:30 | 00:01:30 |  | 2009-01-31 19:00:49 | 1 |  | 00:00:55 | 1
2009-02-01 00:01:33 | 2009-01-31 19:01:33 | 00:01:33 |  | 2009-01-31 19:00:55 | 1 |  | 00:01:05 | 1
2009-02-01 00:01:36 | 2009-01-31 19:01:36 | 00:01:36 |  | 2009-01-31 19:01:05 | 1 |  | 00:01:21 | 1
2009-02-01 00:01:39 | 2009-01-31 19:01:39 | 00:01:39 |  | 2009-01-31 19:01:21 | 1 |  | 00:01:30 | 1
2009-02-01 00:01:41 | 2009-01-31 19:01:41 | 00:01:41 |  | 2009-01-31 19:01:30 | 1 |  | 00:01:33 | 1
2009-02-01 00:01:42 | 2009-01-31 19:01:42 | 00:01:42 |  | 2009-01-31 19:01:33 | 1 |  | 00:01:36 | 1
2009-02-01 00:01:46 | 2009-01-31 19:01:46 | 00:01:46 |  | 2009-01-31 19:01:36 | 1 |  | 00:01:39 | 1
2009-02-01 00:01:49 | 2009-01-31 19:01:49 | 00:01:49 |  | 2009-01-31 19:01:39 | 1 |  | 00:01:41 | 1
2009-02-01 00:01:54 | 2009-01-31 19:01:54 | 00:01:54 |  | 2009-01-31 19:01:41 | 1 |  | 00:01:42 | 1
2009-02-01 00:01:57 | 2009-01-31 19:01:57 | 00:01:57 |  | 2009-01-31 19:01:42 | 1 |  | 00:01:46 | 1
2009-02-01 00:02:01 | 2009-01-31 19:02:01 | 00:02:01 |  | 2009-01-31 19:01:46 | 1 |  | 00:01:49 | 1
2009-02-01 00:02:03 | 2009-01-31 19:02:03 | 00:02:03 |  | 2009-01-31 19:01:49 | 1 |  | 00:01:54 | 1
2009-02-01 00:02:06 | 2009-01-31 19:02:06 | 00:02:06 |  | 2009-01-31 19:01:54 | 1 |  | 00:01:57 | 1
2009-02-01 00:02:24 | 2009-01-31 19:02:24 | 00:02:24 |  | 2009-01-31 19:01:57 | 1 |  | 00:02:01 | 1
2009-02-01 00:02:27 | 2009-01-31 19:02:27 | 00:02:27 |  | 2009-01-31 19:02:01 | 1 |  | 00:02:03 | 1
2009-02-01 00:02:27 | 2009-01-31 19:02:27 | 00:02:27 |  | 2009-01-31 19:02:03 | 1 |  | 00:02:06 | 1
2009-02-01 00:02:29 | 2009-01-31 19:02:29 | 00:02:29 |  | 2009-01-31 19:02:06 | 1 |  | 00:02:24 | 1
2009-02-01 00:02:30 | 2009-01-31 19:02:30 | 00:02:30 |  | 2009-01-31 19:02:24 | 1 |  | 00:02:27 | 2
2009-02-01 00:02:31 | 2009-01-31 19:02:31 | 00:02:31 |  | 2009-01-31 19:02:27 | 2 |  | 00:02:29 | 1
2009-02-01 00:02:33 | 2009-01-31 19:02:33 | 00:02:33 |  | 2009-01-31 19:02:29 | 1 |  | 00:02:30 | 1
2009-02-01 00:02:35 | 2009-01-31 19:02:35 | 00:02:35 |  | 2009-01-31 19:02:30 | 1 |  | 00:02:31 | 1
2009-02-01 00:02:37 | 2009-01-31 19:02:37 | 00:02:37 |  | 2009-01-31 19:02:31 | 1 |  | 00:02:33 | 1
2009-02-01 00:02:37 | 2009-01-31 19:02:37 | 00:02:37 |  | 2009-01-31 19:02:33 | 1 |  | 00:02:35 | 1
2009-02-01 01:57:10 | 2009-01-31 20:57:10 | 01:57:10 |  | 2009-01-31 19:02:35 | 1 |  | 00:02:37 | 2
2009-02-01 01:57:56 | 2009-01-31 20:57:56 | 01:57:56 |  | 2009-01-31 19:02:37 | 2 |  | 01:57:10 | 1
2009-02-01 01:58:01 | 2009-01-31 20:58:01 | 01:58:01 |  | 2009-01-31 20:57:10 | 1 |  | 01:57:56 | 1
2009-02-01 01:58:12 | 2009-01-31 20:58:12 | 01:58:12 |  | 2009-01-31 20:57:56 | 1 |  | 01:58:01 | 1
2009-02-01 01:58:20 | 2009-01-31 20:58:20 | 01:58:20 |  | 2009-01-31 20:58:01 | 1 |  | 01:58:12 | 1
2009-02-01 01:58:30 | 2009-01-31 20:58:30 | 01:58:30 |  | 2009-01-31 20:58:12 | 1 |  | 01:58:20 | 1
2009-02-01 01:58:37 | 2009-01-31 20:58:37 | 01:58:37 |  | 2009-01-31 20:58:20 | 1 |  | 01:58:30 | 1
2009-02-01 01:58:42 | 2009-01-31 20:58:42 | 01:58:42 |  | 2009-01-31 20:58:30 | 1 |  | 01:58:37 | 1
2009-02-01 01:58:44 | 2009-01-31 20:58:44 | 01:58:44 |  | 2009-01-31 20:58:37 | 1 |  | 01:58:42 | 1
2009-02-01 01:59:01 | 2009-01-31 20:59:01 | 01:59:01 |  | 2009-01-31 20:58:42 | 1 |  | 01:58:44 | 1
2009-02-01 01:59:07 | 2009-01-31 20:59:07 | 01:59:07 |  | 2009-01-31 20:58:44 | 1 |  | 01:59:01 | 1
2009-02-01 01:59:31 | 2009-01-31 20:59:31 | 01:59:31 |  | 2009-01-31 20:59:01 | 1 |  | 01:59:07 | 1
2009-02-01 01:59:39 | 2009-01-31 20:59:39 | 01:59:39 |  | 2009-01-31 20:59:07 | 1 |  | 01:59:31 | 1
2009-02-01 01:59:43 | 2009-01-31 20:59:43 | 01:59:43 |  | 2009-01-31 20:59:31 | 1 |  | 01:59:39 | 1
2009-02-01 01:59:57 | 2009-01-31 20:59:57 | 01:59:57 |  | 2009-01-31 20:59:39 | 1 |  | 01:59:43 | 1
2009-02-01 02:00:03 | 2009-01-31 21:00:03 | 02:00:03 |  | 2009-01-31 20:59:43 | 1 |  | 01:59:57 | 1
2009-02-01 02:00:09 | 2009-01-31 21:00:09 | 02:00:09 |  | 2009-01-31 20:59:57 | 1 |  | 02:00:03 | 1
2009-02-01 02:00:14 | 2009-01-31 21:00:14 | 02:00:14 |  | 2009-01-31 21:00:03 | 1 |  | 02:00:09 | 1
2009-02-01 02:00:19 | 2009-01-31 21:00:19 | 02:00:19 |  | 2009-01-31 21:00:09 | 1 |  | 02:00:14 | 1
2009-02-01 02:00:25 | 2009-01-31 21:00:25 | 02:00:25 |  | 2009-01-31 21:00:14 | 1 |  | 02:00:19 | 1
2009-02-01 02:00:32 | 2009-01-31 21:00:32 | 02:00:32 |  | 2009-01-31 21:00:19 | 1 |  | 02:00:25 | 1
2009-02-01 02:01:03 | 2009-01-31 21:01:03 | 02:01:03 |  | 2009-01-31 21:00:25 | 1 |  | 02:00:32 | 1
2009-02-01 02:01:13 | 2009-01-31 21:01:13 | 02:01:13 |  | 2009-01-31 21:00:32 | 1 |  | 02:01:03 | 1
2009-02-01 02:01:24 | 2009-01-31 21:01:24 | 02:01:24 |  | 2009-01-31 21:01:03 | 1 |  | 02:01:13 | 1
2009-02-01 02:01:51 | 2009-01-31 21:01:51 | 02:01:51 |  | 2009-01-31 21:01:13 | 1 |  | 02:01:24 | 1
2009-02-01 02:01:59 | 2009-01-31 21:01:59 | 02:01:59 |  | 2009-01-31 21:01:24 | 1 |  | 02:01:51 | 1
2009-02-01 02:02:12 | 2009-01-31 21:02:12 | 02:02:12 |  | 2009-01-31 21:01:51 | 1 |  | 02:01:59 | 1
2009-02-01 02:02:14 | 2009-01-31 21:02:14 | 02:02:14 |  | 2009-01-31 21:01:59 | 1 |  | 02:02:12 | 1
2009-02-01 02:02:21 | 2009-01-31 21:02:21 | 02:02:21 |  | 2009-01-31 21:02:12 | 1 |  | 02:02:14 | 1
2014-02-17 17:08:44 | 2014-02-17 17:08:44 | 17:08:44 |  | 2009-01-31 21:02:14 | 1 |  | 02:02:21 | 1
2014-02-17 17:40:06 | 2014-02-17 17:40:06 | 17:40:06 |  | 2009-01-31 21:02:21 | 1 |  | 17:08:44 | 1
2014-02-17 17:40:06 | 2014-02-17 17:40:06 | 17:40:06 |  | 2014-02-17 17:08:44 | 1 |  | 17:40:06 | 2
2014-02-17 17:40:38 | 2014-02-17 17:40:38 | 17:40:38 |  | 2014-02-17 17:40:06 | 2 |  | 17:40:38 | 1
2014-02-17 17:41:22 | 2014-02-17 17:41:22 | 17:41:22 |  | 2014-02-17 17:40:38 | 1 |  | 17:41:22 | 1
2014-02-17 17:42:05 | 2014-02-17 17:42:05 | 17:42:05 |  | 2014-02-17 17:41:22 | 1 |  | 17:42:05 | 1
2014-02-17 17:42:53 | 2014-02-17 17:42:53 | 17:42:53 |  | 2014-02-17 17:42:05 | 1 |  | 17:42:53 | 1
2014-02-17 17:44:21 | 2014-02-17 17:44:21 | 17:44:21 |  | 2014-02-17 17:42:53 | 1 |  | 17:44:21 | 1
2014-02-17 17:44:22 | 2014-02-17 17:44:22 | 17:44:22 |  | 2014-02-17 17:44:21 | 1 |  | 17:44:22 | 1
2014-02-17 17:44:38 | 2014-02-17 17:44:38 | 17:44:38 |  | 2014-02-17 17:44:22 | 1 |  | 17:44:38 | 1
2014-02-17 17:44:45 | 2014-02-17 17:44:45 | 17:44:45 |  | 2014-02-17 17:44:38 | 1 |  | 17:44:45 | 1
2014-02-17 17:46:01 | 2014-02-17 17:46:01 | 17:46:01 |  | 2014-02-17 17:44:45 | 1 |  | 17:46:01 | 1
2014-02-17 17:46:19 | 2014-02-17 17:46:19 | 17:46:19 |  | 2014-02-17 17:46:01 | 1 |  | 17:46:19 | 1
2014-02-17 17:46:29 | 2014-02-17 17:46:29 | 17:46:29 |  | 2014-02-17 17:46:19 | 1 |  | 17:46:29 | 1
2014-02-17 17:47:55 | 2014-02-17 17:47:55 | 17:47:55 |  | 2014-02-17 17:46:29 | 1 |  | 17:47:55 | 1
2014-02-17 17:48:17 | 2014-02-17 17:48:17 | 17:48:17 |  | 2014-02-17 17:47:55 | 1 |  | 17:48:17 | 1
2014-02-17 17:48:41 | 2014-02-17 17:48:41 | 17:48:41 |  | 2014-02-17 17:48:17 | 1 |  | 17:48:41 | 1
2014-02-17 17:55:59 | 2014-02-17 17:55:59 | 17:55:59 |  | 2014-02-17 17:48:41 | 1 |  | 17:55:59 | 1
2014-02-17 17:57:57 | 2014-02-17 17:57:57 | 17:57:57 |  | 2014-02-17 17:55:59 | 1 |  | 17:57:57 | 1
2014-02-17 17:58:13 | 2014-02-17 17:58:13 | 17:58:13 |  | 2014-02-17 17:57:57 | 1 |  | 17:58:13 | 1
2014-02-17 17:58:24 | 2014-02-17 17:58:24 | 17:58:24 |  | 2014-02-17 17:58:13 | 1 |  | 17:58:24 | 1
2014-02-17 18:11:25 | 2014-02-17 18:11:25 | 18:11:25 |  | 2014-02-17 17:58:24 | 1 |  | 18:11:25 | 1
2014-02-17 18:11:28 | 2014-02-17 18:11:28 | 18:11:28 |  | 2014-02-17 18:11:25 | 1 |  | 18:11:28 | 1
2014-02-17 18:11:31 | 2014-02-17 18:11:31 | 18:11:31 |  | 2014-02-17 18:11:28 | 1 |  | 18:11:31 | 1
2014-02-17 18:11:32 | 2014-02-17 18:11:32 | 18:11:32 |  | 2014-02-17 18:11:31 | 1 |  | 18:11:32 | 1
2014-02-17 18:11:37 | 2014-02-17 18:11:37 | 18:11:37 |  | 2014-02-17 18:11:32 | 1 |  | 18:11:37 | 1
2014-02-17 18:11:39 | 2014-02-17 18:11:39 | 18:11:39 |  | 2014-02-17 18:11:37 | 1 |  | 18:11:39 | 2
2014-02-17 18:11:39 | 2014-02-17 18:11:39 | 18:11:39 |  | 2014-02-17 18:11:39 | 2 |  | 18:11:42 | 1
2014-02-17 18:11:42 | 2014-02-17 18:11:42 | 18:11:42 |  | 2014-02-17 18:11:42 | 1 |  | 18:11:44 | 1
2014-02-17 18:11:44 | 2014-02-17 18:11:44 | 18:11:44 |  | 2014-02-17 18:11:44 | 1 |  | 18:11:47 | 1
2014-02-17 18:11:47 | 2014-02-17 18:11:47 | 18:11:47 |  | 2014-02-17 18:11:47 | 1 |  | 18:11:50 | 1
2014-02-17 18:11:50 | 2014-02-17 18:11:50 | 18:11:50 |  | 2014-02-17 18:11:50 | 1 |  | 18:11:52 | 1
2014-02-17 18:11:52 | 2014-02-17 18:11:52 | 18:11:52 |  | 2014-02-17 18:11:52 | 1 |  | 18:11:54 | 1
2014-02-17 18:11:54 | 2014-02-17 18:11:54 | 18:11:54 |  | 2014-02-17 18:11:54 | 1 |  | 18:11:55 | 1
2014-02-17 18:11:55 | 2014-02-17 18:11:55 | 18:11:55 |  | 2014-02-17 18:11:55 | 1 |  | 18:11:56 | 1
2014-02-17 18:11:56 | 2014-02-17 18:11:56 | 18:11:56 |  | 2014-02-17 18:11:56 | 1 |  | 19:00:49 | 1
 |  |  |  | Grand Total | 92 |  | Grand Total | 92