Spreadsheet: 696157d1600677916-getting-difference-between-dates-from-2-date-ranges-then-categorize-it-in-another-table-testexcel
Sheet: All issue list

Created | Closed | ASD | AED | Groups
2020-09-18 12:15:00 |  | 2020-09-18 00:00:00 |  | GROUP B
2020-09-18 10:47:00 |  | 2020-09-18 00:00:00 |  | GROUP B
2020-09-17 14:37:00 |  | 2020-09-18 00:00:00 |  | GROUP B |  |  | Month | More than 5 days | More than 10 days | More than 20 days | Total
2020-09-17 12:55:00 |  | 2020-09-17 00:00:00 |  | GROUP B |  |  | January
2020-09-17 12:40:00 |  | 2020-09-17 00:00:00 |  | GROUP B |  |  | February
2020-09-16 14:41:00 |  | 2020-09-17 00:00:00 |  | GROUP B |  |  | March
2020-09-16 14:35:00 |  | 2020-09-17 00:00:00 |  | GROUP B |  |  | April
2020-09-16 12:41:00 |  | 2020-09-16 00:00:00 |  | GROUP B |  |  | May
2020-09-16 10:04:00 |  | 2020-09-16 00:00:00 |  | GROUP B |  |  | June
2020-09-16 08:33:00 | 2020-09-18 10:04:00 | 2020-09-16 00:00:00 | 2020-09-18 00:00:00 | GROUP B |  |  | July
2020-09-15 17:10:00 | 2020-09-18 09:01:00 | 2020-09-15 00:00:00 | 2020-09-18 00:00:00 | GROUP B |  |  | August
2020-09-15 17:05:00 | 2020-09-18 16:32:00 | 2020-09-16 00:00:00 | 2020-09-18 00:00:00 | GROUP B |  |  | September
2020-09-15 16:52:00 | 2020-09-18 16:32:00 | 2020-09-16 00:00:00 | 2020-09-18 00:00:00 | GROUP B |  |  | October
2020-09-15 12:57:00 | 2020-09-16 14:29:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | GROUP B |  |  | November
2020-09-15 12:30:00 | 2020-09-16 14:31:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | GROUP B |  |  | December
2020-09-15 10:58:00 | 2020-09-16 14:28:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | GROUP B
2020-09-15 10:26:00 | 2020-09-18 09:00:00 | 2020-09-15 00:00:00 | 2020-09-18 00:00:00 | GROUP B
2020-09-14 17:03:00 | 2020-09-16 13:54:00 | 2020-09-15 00:00:00 | 2020-09-16 00:00:00 | GROUP B
2020-09-14 16:25:00 | 2020-09-18 08:39:00 | 2020-09-15 00:00:00 | 2020-09-18 00:00:00 | GROUP B
2020-09-14 14:10:00 | 2020-09-17 10:26:00 | 2020-09-14 00:00:00 | 2020-09-17 00:00:00 | GROUP B
2020-09-14 13:54:00 | 2020-09-16 09:28:00 | 2020-09-14 00:00:00 | 2020-09-16 00:00:00 | GROUP B
2020-09-14 12:57:00 | 2020-09-18 08:14:00 | 2020-09-14 00:00:00 | 2020-09-18 00:00:00 | GROUP B
2020-09-14 12:47:00 | 2020-09-16 13:55:00 | 2020-09-14 00:00:00 | 2020-09-16 00:00:00 | GROUP B
2020-09-14 12:27:00 | 2020-09-18 08:38:00 | 2020-09-14 00:00:00 | 2020-09-18 00:00:00 | GROUP B
2020-09-14 10:39:00 |  | 2020-09-14 00:00:00 |  | GROUP B
2020-09-14 10:39:00 | 2020-09-16 08:13:00 | 2020-09-14 00:00:00 | 2020-09-16 00:00:00 | GROUP B
2020-09-14 10:16:00 | 2020-09-16 16:39:00 | 2020-09-14 00:00:00 | 2020-09-16 00:00:00 | GROUP B
2020-09-14 10:00:00 |  | 2020-09-15 00:00:00 |  | GROUP B
2020-09-11 17:08:00 | 2020-09-16 13:56:00 | 2020-09-14 00:00:00 | 2020-09-16 00:00:00 | GROUP B
2020-09-11 16:18:00 |  | 2020-09-16 00:00:00 |  | GROUP A
2020-09-11 15:02:00 | 2020-09-15 19:27:00 | 2020-09-11 00:00:00 | 2020-09-15 00:00:00 | GROUP B
2020-09-10 15:55:00 | 2020-09-17 10:15:00 | 2020-09-11 00:00:00 | 2020-09-17 00:00:00 | GROUP B
2020-09-10 13:18:00 | 2020-09-15 09:06:00 | 2020-09-10 00:00:00 | 2020-09-15 00:00:00 | GROUP B
2020-09-10 10:34:00 | 2020-09-14 16:08:00 | 2020-09-10 00:00:00 | 2020-09-14 00:00:00 | GROUP B
2020-09-10 06:45:00 |  | 2020-09-11 00:00:00 |  | GROUP B
2020-09-09 17:09:00 | 2020-09-11 17:06:00 | 2020-09-10 00:00:00 | 2020-09-11 00:00:00 | GROUP C
2020-09-09 16:47:00 | 2020-09-11 17:06:00 | 2020-09-10 00:00:00 | 2020-09-11 00:00:00 | GROUP C
2020-09-09 12:08:00 | 2020-09-14 16:10:00 | 2020-09-10 00:00:00 | 2020-09-14 00:00:00 | GROUP B
2020-09-09 12:04:00 |  | 2020-09-10 00:00:00 |  | GROUP B
2020-09-09 07:55:00 | 2020-09-13 11:44:00 | 2020-09-09 00:00:00 | 2020-09-14 00:00:00 | GROUP B
2020-09-08 16:01:00 |  | 2020-09-08 00:00:00 |  | GROUP A
2020-09-07 12:42:00 | 2020-09-15 15:34:00 | 2020-09-07 00:00:00 | 2020-09-15 00:00:00 | GROUP B
2020-09-04 16:39:00 | 2020-09-09 08:43:00 | 2020-09-07 00:00:00 | 2020-09-09 00:00:00 | GROUP B
2020-09-02 10:46:00 | 2020-09-09 14:02:00 | 2020-09-04 00:00:00 | 2020-09-09 00:00:00 | GROUP C
2020-09-01 16:48:00 | 2020-09-11 09:13:00 | 2020-09-02 00:00:00 | 2020-09-11 00:00:00 | GROUP B
2020-09-01 14:22:00 | 2020-09-11 13:32:00 | 2020-09-02 00:00:00 | 2020-09-11 00:00:00 | GROUP B
2020-09-01 11:01:00 | 2020-09-09 14:47:00 | 2020-09-04 00:00:00 | 2020-09-09 00:00:00 | GROUP B
2020-09-01 10:27:00 | 2020-09-07 15:56:00 | 2020-09-01 00:00:00 | 2020-09-07 00:00:00 | GROUP B
2020-08-31 17:26:00 | 2020-09-03 12:37:00 | 2020-09-01 00:00:00 | 2020-09-03 00:00:00 | GROUP B
2020-08-31 15:51:00 | 2020-09-08 09:00:00 | 2020-09-02 00:00:00 | 2020-09-08 00:00:00 | GROUP B
2020-08-28 16:54:00 | 2020-09-03 09:00:00 | 2020-09-01 00:00:00 | 2020-09-03 00:00:00 | GROUP B
2020-08-28 16:34:00 | 2020-09-02 16:32:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | GROUP B
2020-08-28 12:39:00 | 2020-09-07 10:20:00 | 2020-09-01 00:00:00 | 2020-09-07 00:00:00 | GROUP B
2020-08-28 12:10:00 | 2020-09-03 10:27:00 | 2020-09-01 00:00:00 | 2020-09-03 00:00:00 | GROUP C
2020-08-28 08:56:00 | 2020-09-09 13:33:00 | 2020-09-01 00:00:00 | 2020-09-09 00:00:00 | GROUP B
2020-08-27 17:34:00 | 2020-09-04 12:35:00 | 2020-08-28 00:00:00 | 2020-09-04 00:00:00 | GROUP B
2020-08-27 14:42:00 | 2020-09-01 09:38:00 | 2020-08-27 00:00:00 | 2020-09-01 00:00:00 | GROUP B
2020-08-27 09:21:00 |  | 2020-08-27 00:00:00 |  | GROUP A
2020-08-26 14:03:00 | 2020-09-02 14:17:00 | 2020-08-26 00:00:00 | 2020-09-02 00:00:00 | GROUP B
2020-08-25 13:23:00 | 2020-08-28 13:22:00 | 2020-08-25 00:00:00 | 2020-08-28 00:00:00 | GROUP B
2020-08-25 13:18:00 | 2020-08-31 16:38:00 | 2020-08-25 00:00:00 | 2020-08-31 00:00:00 | GROUP B
2020-08-25 12:53:00 | 2020-09-02 10:33:00 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | GROUP B
2020-08-24 15:59:00 | 2020-08-27 15:39:00 | 2020-08-25 00:00:00 | 2020-08-27 00:00:00 | GROUP B
2020-08-24 14:59:00 | 2020-08-27 15:42:00 | 2020-08-24 00:00:00 | 2020-08-27 00:00:00 | GROUP B
2020-08-21 18:09:00 | 2020-08-31 15:16:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | GROUP C
2020-08-21 14:34:00 | 2020-08-26 14:33:00 | 2020-08-24 00:00:00 | 2020-08-26 00:00:00 | GROUP B
2020-08-19 14:53:00 | 2020-09-01 08:10:00 | 2020-08-24 00:00:00 | 2020-09-01 00:00:00 | GROUP C
2020-08-18 10:08:00 | 2020-08-21 15:18:00 | 2020-08-19 00:00:00 | 2020-08-21 00:00:00 | GROUP C
2020-08-17 16:07:00 | 2020-08-20 17:04:00 | 2020-08-17 00:00:00 | 2020-08-20 00:00:00 | GROUP B
2020-08-17 15:25:00 | 2020-08-24 16:43:00 | 2020-08-19 00:00:00 | 2020-08-24 00:00:00 | GROUP C
2020-08-17 15:09:00 | 2020-08-21 11:50:00 | 2020-08-19 00:00:00 | 2020-08-21 00:00:00 | GROUP C
2020-08-17 15:07:00 | 2020-08-21 12:25:00 | 2020-08-20 00:00:00 | 2020-08-21 00:00:00 | GROUP C
2020-08-17 15:04:00 | 2020-08-25 12:33:00 | 2020-08-19 00:00:00 | 2020-08-25 00:00:00 | GROUP C
2020-08-17 10:00:00 | 2020-08-20 17:03:00 | 2020-08-17 00:00:00 | 2020-08-20 00:00:00 | GROUP B
2020-08-17 09:24:00 | 2020-08-18 13:13:00 | 2020-08-17 00:00:00 | 2020-08-18 00:00:00 | GROUP B
2020-08-07 15:14:00 | 2020-08-27 15:06:00 | 2020-08-11 00:00:00 | 2020-08-27 00:00:00 | GROUP C
2020-08-07 14:47:00 | 2020-08-21 12:23:00 | 2020-08-11 00:00:00 | 2020-08-21 00:00:00 | GROUP C
2020-08-06 17:04:00 | 2020-08-21 12:06:00 | 2020-08-07 00:00:00 | 2020-08-21 00:00:00 | GROUP C
2020-08-06 16:58:00 | 2020-08-21 12:29:00 | 2020-08-07 00:00:00 | 2020-08-21 00:00:00 | GROUP C
2020-08-03 17:55:00 | 2020-08-06 12:19:00 | 2020-08-04 00:00:00 | 2020-08-06 00:00:00 | GROUP C
2020-08-03 15:03:00 | 2020-08-20 12:45:00 | 2020-08-04 00:00:00 | 2020-08-20 00:00:00 | GROUP C
2020-08-03 14:00:00 | 2020-08-17 15:00:00 | 2020-08-04 00:00:00 | 2020-08-17 00:00:00 | GROUP C
2020-07-30 12:56:00 | 2020-08-18 10:33:00 | 2020-08-03 00:00:00 | 2020-08-18 00:00:00 | GROUP C
2020-07-30 12:51:00 | 2020-08-18 10:32:00 | 2020-08-03 00:00:00 | 2020-08-18 00:00:00 | GROUP C
2020-07-28 16:49:00 | 2020-08-20 18:45:00 | 2020-07-29 00:00:00 | 2020-08-20 00:00:00 | GROUP C
2020-07-28 13:56:00 | 2020-08-20 14:15:00 | 2020-07-29 00:00:00 | 2020-08-20 00:00:00 | GROUP C
2020-07-28 13:53:00 | 2020-07-30 14:46:00 | 2020-07-29 00:00:00 | 2020-07-30 00:00:00 | GROUP C
2020-07-28 13:51:00 | 2020-08-03 14:43:00 | 2020-07-29 00:00:00 | 2020-08-03 00:00:00 | GROUP C
2020-07-28 13:15:00 | 2020-07-30 14:43:00 | 2020-07-29 00:00:00 | 2020-07-30 00:00:00 | GROUP C
2020-07-28 16:38:00 | 2020-08-05 13:45:00 | 2020-07-28 00:00:00 | 2020-08-05 00:00:00 | GROUP A
2020-07-03 14:52:00 | 2020-07-10 18:20:00 | 2020-07-06 00:00:00 | 2020-07-10 00:00:00 | GROUP A
2020-06-30 16:48:00 | 2020-07-03 18:13:00 | 2020-07-01 00:00:00 | 2020-07-03 00:00:00 | GROUP A
2020-06-26 18:22:00 | 2020-07-02 15:09:00 | 2020-06-29 00:00:00 | 2020-07-02 00:00:00 | GROUP A
2020-06-26 14:31:00 | 2020-07-03 15:23:00 | 2020-06-30 00:00:00 | 2020-07-03 00:00:00 | GROUP A
2020-06-25 16:28:00 | 2020-06-29 15:21:00 | 2020-06-26 00:00:00 | 2020-06-29 00:00:00 | GROUP A
2020-06-24 14:42:00 | 2020-06-30 09:39:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | GROUP A
2020-06-16 08:45:00 | 2020-06-23 07:42:00 | 2020-06-17 00:00:00 | 2020-06-23 00:00:00 | GROUP A
2020-06-12 14:12:00 | 2020-06-22 10:19:00 | 2020-06-16 00:00:00 | 2020-06-22 00:00:00 | GROUP A
2020-06-11 10:17:00 | 2020-06-22 10:25:00 | 2020-06-11 00:00:00 | 2020-06-22 00:00:00 | GROUP A
2020-06-10 14:56:00 | 2020-06-18 10:41:00 | 2020-06-15 00:00:00 | 2020-06-18 00:00:00 | GROUP A
2020-06-10 13:42:00 | 2020-07-01 08:45:00 | 2020-06-15 00:00:00 | 2020-07-01 00:00:00 | GROUP A
2020-06-10 10:31:00 | 2020-06-18 17:53:00 | 2020-06-11 00:00:00 | 2020-06-18 00:00:00 | GROUP A
2020-06-09 15:12:00 | 2020-06-16 12:35:00 | 2020-06-10 00:00:00 | 2020-06-16 00:00:00 | GROUP A
2020-06-09 14:51:00 | 2020-06-23 10:04:00 | 2020-06-15 00:00:00 | 2020-06-23 00:00:00 | GROUP A
2020-06-08 22:18:00 | 2020-06-15 11:39:00 | 2020-06-10 00:00:00 | 2020-06-15 00:00:00 | GROUP A
2020-06-05 15:23:00 | 2020-07-01 08:26:00 | 2020-06-08 00:00:00 | 2020-07-01 00:00:00 | GROUP A
2020-06-05 11:37:00 | 2020-06-10 13:18:00 | 2020-06-08 00:00:00 | 2020-06-10 00:00:00 | GROUP A
2020-06-05 09:11:00 | 2020-06-10 09:59:00 | 2020-06-08 00:00:00 | 2020-06-10 00:00:00 | GROUP A
2020-06-04 14:11:00 | 2020-06-19 07:46:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | GROUP A
2020-06-04 13:35:00 | 2020-06-08 10:59:00 | 2020-06-05 00:00:00 | 2020-06-08 00:00:00 | GROUP A
2020-06-04 11:51:00 | 2020-06-15 15:22:00 | 2020-06-05 00:00:00 | 2020-06-15 00:00:00 | GROUP A
2020-06-02 18:43:00 | 2020-06-05 15:02:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | GROUP A
2020-06-01 13:49:00 | 2020-06-03 12:01:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | GROUP A
2020-06-01 13:45:00 | 2020-06-02 12:59:00 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | GROUP A
2020-05-29 16:17:00 | 2020-06-05 08:42:00 | 2020-06-02 00:00:00 | 2020-06-05 00:00:00 | GROUP A
2020-05-29 10:40:00 | 2020-06-30 16:46:00 | 2020-06-02 00:00:00 | 2020-06-30 00:00:00 | GROUP A
2020-05-29 10:00:00 | 2020-06-05 08:07:00 | 2020-06-02 00:00:00 | 2020-06-05 00:00:00 | GROUP A
2020-05-29 09:59:00 | 2020-06-05 10:08:00 | 2020-05-29 00:00:00 | 2020-06-05 00:00:00 | GROUP A
2020-05-29 09:56:00 | 2020-06-02 18:40:00 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | GROUP A
2020-05-29 09:54:00 | 2020-06-04 08:19:00 | 2020-05-29 00:00:00 | 2020-06-04 00:00:00 | GROUP A
2020-05-29 09:53:00 | 2020-06-08 09:36:00 | 2020-05-29 00:00:00 | 2020-06-08 00:00:00 | GROUP A
2020-05-29 09:51:00 | 2020-06-02 18:23:00 | 2020-05-29 00:00:00 | 2020-06-02 00:00:00 | GROUP A
2020-05-28 15:50:00 | 2020-07-01 09:20:00 | 2020-05-29 00:00:00 | 2020-07-01 00:00:00 | GROUP A
2020-05-28 14:14:00 | 2020-06-05 15:06:00 | 2020-05-29 00:00:00 | 2020-06-05 00:00:00 | GROUP A
2020-05-28 08:18:00 | 2020-06-23 09:32:00 | 2020-05-28 00:00:00 | 2020-06-23 00:00:00 | GROUP A
2020-05-27 15:21:00 | 2020-06-25 13:57:00 | 2020-05-29 00:00:00 | 2020-06-25 00:00:00 | GROUP A
2020-05-27 13:51:00 | 2020-06-05 15:04:00 | 2020-05-28 00:00:00 | 2020-06-05 00:00:00 | GROUP A
2020-05-27 09:11:00 | 2020-06-05 15:02:00 | 2020-05-28 00:00:00 | 2020-06-05 00:00:00 | GROUP A
2020-05-22 17:30:00 | 2020-05-27 19:45:00 | 2020-05-26 00:00:00 | 2020-05-27 00:00:00 | GROUP A