Spreadsheet: 704254d1605464693-need-formula-that-analyses-time-and-date-cell-differences-by-date-and-hour-duration-analysis
Sheet: Data

Send At | Done At |  | Date | Time | Duration |  | Date | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
01/09/2020 15:02:40 | 01/09/2020 15:02:44 |  |  |  |  |  | 2020-09-01 00:00:00
01/09/2020 15:06:22 | 01/09/2020 15:06:23
01/09/2020 15:07:14 | 01/09/2020 15:07:17
01/09/2020 15:08:26 | 01/09/2020 15:08:28
01/09/2020 16:38:32 | 01/09/2020 [NAME] |  |  |  |  |  | S/Be:
01/09/2020 16:38:49 | 01/09/2020 16:38:50 |  |  |  |  |  | 2020-09-01 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - |  |  |  |  |  |  | - | - | -
01/09/2020 16:38:54 | 01/09/2020 16:38:55 |  |  |  |  |  |  | - |  | - | - | - | - | - | - |  |  |  |  |  |  |  |  |  |  |  |  | - | - | - | -
01/09/2020 16:39:04 | 01/09/2020 16:39:05 |  |  |  |  |  |  |  | - | - |  | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
01/09/2020 17:11:39 | 01/09/2020 17:11:40
01/09/2020 [NAME] | 01/09/2020 18:03:13 |  |  |  |  |  | SUMIFS($F$1:$F$122,$D$2:$D$122,$H2,$E$2:$E$122,"<0",$E$2:$E$122,"<"&J$1)/COUNTIFS($D$2:$D$122,$IH1,$E$2:$E$122,">0",$E$2:$E$122,"<"&J$1)
01/09/2020 18:03:39 | 01/09/2020 18:03:40
01/09/2020 18:03:39 | 01/09/2020 18:03:39
01/09/2020 18:03:45 | 01/09/2020 18:03:46
01/09/2020 18:03:50 | 01/09/2020 18:03:51
01/09/2020 19:05:08 | 01/09/2020 19:05:09
01/09/2020 20:47:17 | 01/09/2020 20:47:18
01/09/2020 20:47:35 | 01/09/2020 20:47:37
01/09/2020 20:47:35 | 01/09/2020 20:47:37
01/09/2020 20:47:45 | 01/09/2020 20:47:45
01/09/2020 20:47:54 | 01/09/2020 20:47:55
02/09/2020 01:39:34 | 02/09/2020 01:39:36
02/09/2020 01:39:42 | 02/09/2020 01:39:43
02/09/2020 01:40:35 | 02/09/2020 01:40:36
02/09/2020 01:40:51 | 02/09/2020 01:40:52
02/09/2020 07:54:53 | 02/09/2020 07:54:54
02/09/2020 07:54:59 | 02/09/2020 07:54:59
02/09/2020 07:55:06 | 02/09/2020 07:55:06
02/09/2020 08:01:57 | 02/09/2020 09:16:13
02/09/2020 [NAME] | 02/09/2020 08:02:47
02/09/2020 08:03:08 | 02/09/2020 08:05:39
02/09/2020 08:03:20 | 02/09/2020 08:03:25
02/09/2020 [NAME] | 02/09/2020 09:17:29
02/09/2020 [NAME] | 02/09/2020 09:28:01
02/09/2020 09:46:07 | 02/09/2020 09:46:08
02/09/2020 09:58:47 | 02/09/2020 09:58:55
02/09/2020 10:03:06 | 02/09/2020 10:03:07
02/09/2020 10:07:19 | 02/09/2020 10:07:20
02/09/2020 10:21:40 | 02/09/2020 10:21:44
02/09/2020 10:34:02 | 02/09/2020 10:34:03
02/09/2020 10:48:41 | 02/09/2020 10:48:41
02/09/2020 11:04:24 | 02/09/2020 11:04:25
02/09/2020 [NAME] | 02/09/2020 11:11:43
02/09/2020 11:25:41 | 02/09/2020 11:25:48
02/09/2020 11:25:57 | 02/09/2020 11:25:59
02/09/2020 11:41:29 | 02/09/2020 11:41:33
02/09/2020 12:13:21 | 02/09/2020 12:13:22
02/09/2020 12:44:06 | 02/09/2020 12:44:12
02/09/2020 13:10:01 | 02/09/2020 13:10:07
02/09/2020 13:17:52 | 02/09/2020 13:17:54
02/09/2020 13:24:54 | 02/09/2020 13:24:58
02/09/2020 [NAME] | 02/09/2020 13:39:03
02/09/2020 13:49:29 | 02/09/2020 13:49:34
02/09/2020 13:51:02 | 02/09/2020 13:55:40
02/09/2020 14:05:44 | 02/09/2020 14:05:46
02/09/2020 [NAME] | 02/09/2020 14:18:53
02/09/2020 14:47:47 | 02/09/2020 14:47:49
02/09/2020 15:17:05 | 02/09/2020 [NAME]
02/09/2020 15:38:22 | 02/09/2020 15:38:41
02/09/2020 15:52:32 | 02/09/2020 15:52:37
02/09/2020 16:02:12 | 02/09/2020 16:02:15
02/09/2020 16:13:59 | 02/09/2020 16:14:00
2020-09-02 16:24:41 | 2020-09-02 16:24:47
02/09/2020 17:07:04 | 02/09/2020 17:07:05
02/09/2020 17:30:54 | 02/09/2020 17:30:55
02/09/2020 18:43:50 | 02/09/2020 18:43:52
02/09/2020 18:48:29 | 02/09/2020 18:48:31
02/09/2020 19:18:04 | 02/09/2020 19:18:05
03/09/2020 00:02:20 | 03/09/2020 00:02:21
2020-09-03 00:25:40 | 2020-09-03 00:31:41
03/09/2020 00:39:23 | 03/09/2020 00:39:24
03/09/2020 03:30:24 | 03/09/2020 03:30:25
2020-09-03 03:41:16 | 2020-09-03 03:41:37
2020-09-03 05:00:04 | 2020-09-03 05:08:05
2020-09-03 05:17:36 | 2020-09-03 05:17:39
03/09/2020 05:28:36 | 03/09/2020 05:28:37
2020-09-03 05:36:07 | 2020-09-03 05:36:18
2020-09-03 05:49:20 | 2020-09-03 05:49:20
03/09/2020 07:47:27 | 03/09/2020 07:47:29
03/09/2020 07:59:03 | 03/09/2020 [NAME]
03/09/2020 08:00:06 | 03/09/2020 08:00:07
03/09/2020 [NAME] | 03/09/2020 08:06:09
03/09/2020 08:10:38 | 03/09/2020 08:10:42
03/09/2020 09:17:53 | 03/09/2020 09:17:54
03/09/2020 09:29:52 | 2020-09-03 09:29:57
03/09/2020 09:38:36 | 03/09/2020 09:38:43
03/09/2020 09:45:57 | 03/09/2020 09:46:13
03/09/2020 09:58:46 | 03/09/2020 09:58:48
03/09/2020 10:18:06 | 03/09/2020 10:18:07
03/09/2020 10:25:01 | 03/09/2020 10:25:26
03/09/2020 10:32:00 | 03/09/2020 10:32:07
03/09/2020 10:34:17 | 03/09/2020 10:34:22
03/09/2020 10:48:41 | 03/09/2020 10:49:00
03/09/2020 10:53:45 | 03/09/2020 10:53:49
03/09/2020 11:08:39 | 03/09/2020 11:08:40
03/09/2020 11:19:58 | 03/09/2020 11:19:59
03/09/2020 11:25:49 | 03/09/2020 11:25:50
03/09/2020 11:41:24 | 03/09/2020 11:41:25
03/09/2020 11:51:53 | 03/09/2020 11:51:58
03/09/2020 12:10:24 | 03/09/2020 12:11:34
03/09/2020 12:21:46 | 03/09/2020 12:21:47
03/09/2020 12:30:53 | 03/09/2020 12:30:53
03/09/2020 12:41:25 | 03/09/2020 12:41:26
03/09/2020 12:52:56 | 03/09/2020 12:52:57
03/09/2020 13:06:31 | 03/09/2020 13:06:32
03/09/2020 13:19:30 | 03/09/2020 13:19:32
03/09/2020 13:35:58 | 03/09/2020 13:35:59
03/09/2020 13:50:02 | 03/09/2020 13:50:03
03/09/2020 13:53:05 | 03/09/2020 13:53:06
03/09/2020 14:07:35 | 03/09/2020 14:07:38
03/09/2020 15:23:12 | 03/09/2020 15:23:13
03/09/2020 15:31:06 | 03/09/2020 15:34:33
03/09/2020 15:31:42 | 03/09/2020 15:34:33
03/09/2020 16:01:00 | 03/09/2020 16:01:01
03/09/2020 16:01:11 | 03/09/2020 16:01:12
03/09/2020 17:06:24 | 03/09/2020 17:06:26
2020-09-03 17:16:40 | 2020-09-03 17:16:42
2020-09-03 17:36:40 | 2020-09-03 17:36:42
03/09/2020 19:02:59 | 03/09/2020 19:03:01
03/09/2020 19:03:46 | 03/09/2020 19:03:47
03/09/2020 23:54:02 | 03/09/2020 23:54:08
03/09/2020 23:54:33 | 03/09/2020 23:54:43