Spreadsheet: 828940d1683802813-how-to-find-the-value-count-between-two-time-slots-sample-sheet_find-the-time-slot
Sheet: Input sheet

Month | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON | Power OFF | Power ON
2022-05-01 00:00:00 | 09:57:15 | 10:49:43 | 10:55:46 | 11:42:16 | 12:01:18 | 12:12:31 | 12:33:56 | 13:19:03 | 13:31:49 | 13:39:03 | 15:39:48 | 15:51:21 | 16:22:04 | 16:27:00 | 16:27:06 | 17:12:37 | 17:48:03 | 18:09:07 | 21:01:23 | 21:03:17 | - | - | - | - | - | - | - | -
2022-05-02 00:00:00 | 09:51:25 | 11:44:25 | 12:08:57 | 14:09:20 | 14:09:21 | 14:30:51 | 14:30:52 | 16:03:51 | 16:05:53 | 16:21:10 | 16:22:19 | 18:43:09 | 18:43:10 | 18:45:19 | 18:45:21 | 18:50:04 | 18:50:10 | 19:03:28 | 19:05:26 | - | - | - | - | - | - | - | - | -
2022-05-03 00:00:00 | 01:04:48 | 10:51:12 | 10:51:13 | 11:03:10 | 12:05:19 | 12:24:47 | 12:25:38 | 12:35:33 | 12:35:50 | 12:42:49 | 12:46:37 | 12:53:42 | 12:57:41 | 13:02:37 | 13:02:39 | 13:23:22 | 14:56:41 | 15:33:10 | 15:48:19 | 15:51:15 | 16:27:35 | 17:05:19 | 17:35:33 | 17:46:26 | 17:48:09 | 18:10:11 | 19:24:21 | 20:01:05
2022-05-04 00:00:00 | 07:05:16 | 07:25:16 | 07:48:30 | 08:32:01 | 08:32:05 | 09:30:53 | 09:44:47 | 09:48:38 | 09:54:46 | 10:02:19 | 10:10:49 | 11:45:26 | 12:26:44 | 12:48:00 | 15:15:32 | 16:52:25 | 17:51:26 | 19:22:15 | - | - | - | - | - | - | - | - | - | -
2022-05-05 00:00:00 | 05:54:40 | 06:00:54 | 06:01:01 | 06:04:53 | 06:05:25 | 06:31:12 | 06:37:16 | 08:08:33 | 08:15:42 | 08:27:48 | 08:41:56 | 09:49:27 | 09:49:38 | 13:27:41 | 15:46:19 | 16:16:45 | 16:52:08 | 17:52:18 | 17:56:42 | 18:09:04 | 19:18:56 | 19:27:33 | - | - | - | - | - | -
2022-05-06 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
2022-05-07 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
2022-05-08 00:00:00 | 11:22:35 | 11:48:37 | 11:48:38 | 12:55:32 | 12:55:33 | 13:42:28 | 13:42:46 | 14:31:15 | 14:31:24 | 14:41:55 | 14:41:56 | 14:55:29 | 18:49:06 | 19:01:14 | 19:52:51 | 20:05:21 | 22:58:47 | - | - | - | - | - | - | - | - | - | - | -
2022-05-09 00:00:00 | 09:03:42 | 10:47:43 | 10:47:44 | 11:08:29 | 11:08:30 | 11:35:25 | 11:35:26 | 13:10:19 | 14:17:42 | 14:28:35 | 16:10:48 | 16:30:15 | 18:06:32 | 18:13:40 | 21:12:30 | - | - | - | - | - | - | - | - | - | - | - | - | -
2022-05-10 00:00:00 | 06:25:48 | 07:15:38 | 07:15:40 | 07:28:45 | 08:57:30 | 09:54:19 | 09:54:20 | 10:09:39 | 10:09:40 | 10:16:11 | 10:16:12 | 10:30:11 | 12:01:38 | 12:36:00 | 12:36:01 | 12:49:07 | 14:37:36 | 14:53:50 | 15:19:55 | 15:45:15 | 15:45:16 | 15:57:39 | 17:14:46 | 17:25:53 | 17:26:06 | 18:47:51 | 19:10:54 | 20:01:52
2022-05-11 00:00:00 | 08:36:27 | 09:37:43 | 11:12:23 | 12:05:07 | 12:31:55 | 16:00:44 | 16:46:04 | 17:29:28 | 20:39:25 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
2022-05-12 00:00:00 | 12:41:42 | 14:05:41 | 18:40:14 | 18:44:46 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
2022-05-13 00:00:00 | 16:03:48 | 16:05:37 | 19:44:57 | 20:29:49 | 20:29:54 | 20:45:26 | 20:45:27 | 22:53:50 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
2022-05-14 00:00:00 | 04:17:15 | 04:34:13 | 04:38:58 | 04:47:22 | 04:51:55 | 06:35:07 | 06:35:09 | 08:17:04 | 08:17:06 | 08:41:49 | 08:42:07 | 08:43:38 | 08:44:01 | 08:48:13 | 08:48:33 | 09:23:10 | 09:24:17 | 09:46:59 | 09:49:29 | 09:51:19 | 10:27:13 | 10:49:25 | 12:19:14 | 12:29:52 | 13:04:35 | 13:29:03 | 13:35:20 | 13:51:58
2022-05-15 00:00:00 | 04:44:36 | 04:50:21 | 07:52:40 | 08:11:04 | 08:21:05 | 08:39:57 | 08:55:58 | 09:11:08 | 10:04:59 | 10:22:44 | 10:57:46 | 11:09:38 | 16:43:41 | 17:10:46 | 17:30:28 | 17:47:36 | 18:50:00 | 19:14:36 | - | - | - | - | - | - | - | - | - | -
2022-05-16 00:00:00 | 11:51:45 | 12:07:13 | 12:07:14 | 15:19:38 | 16:47:51 | 17:09:07 | 17:39:27 | 17:51:29 | 18:24:38 | 18:35:56 | 21:18:09 | 21:26:26 | 21:31:45 | 21:33:45 | 21:34:04 | 21:50:34 | 23:17:13 | 23:20:56 | 23:21:12 | 23:22:41 | 23:22:43 | 23:27:28 | 23:29:57 | 23:34:59 | 23:35:13 | 23:39:04 | 23:39:06 | -