Spreadsheet: 678137d1589729376-custom-24-hours-shift-calculation-test-shifts
Sheet: Sheet1

id | Shift | Day | Weekday number | Priority | Incident Created on | Closed-Date | id | magnitude | historical | formattedClosedDate | endTime | tokensAsString | deviceCount | userCount | attackerId | formattedStartTime | formattedEndTime | formattedLastEventTime | formattedDuration | assignedToUser | username | dismissedCode | allNotes | targetNetwork | startTimeAbs | endTimeAbs | targetNetworkDescription | attackerNetwork | [NAME] | remoteTargetCount | localTargetCount | targetNetworkCount | domainName
 |  |  |  | Low |  |  | 21949 | 7 | False |  | Thu May 14 15:00:41 AST 2020 | 199459|1|199585|199425|199360|199559|199493|199428|199371|199531|199400|199447|199381|199477|199541|199573|199451|199391|199550 | 2 | 0 | 64 | May 14, 2020, 12:00:16 AM | May 14, 2020, 3:00:41 PM | 38m 52s | 15h 24s | True | [NAME] | 0 |  | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | 1589403616900 | 1589457641287 | Multiple (2) | Central_Region.Riyadh.DC.DMZ.PRODUCTION1 | 10.179.5.144 | 0 | 6 | 2 | Default Domain
 |  |  |  | Low |  |  | 21994 | 3 | False |  | Thu May 14 14:13:59 AST 2020 | 1|199552|199430|199429|199435|199434|199432|199496|199439|199438|199437|199436|199571|199443|199570|199506|199442|199441|199445|199577|199448|199519|199521|199527|199526|199525 | 2 | 4 | 82037 | May 14, 2020, 4:58:00 AM | May 14, 2020, 2:13:59 PM | 1h 25m 34s | 9h 15m 59s | True | [NAME] | 0 |  | Central_Region.Riyadh.DC.DMZ.PRODUCTION2 | 1589421480119 | 1589454839264 | Multiple (3) | other | 37.42.136.78 | 0 | 21 | 3 | Default Domain
 |  |  |  | Low |  |  | 21951 | 5 | False |  | Thu May 14 04:43:12 AST 2020 | 1|199424 | 2 | 2 | 40700 | May 14, 2020, 12:02:11 AM | May 14, 2020, 4:43:12 AM | 10h 56m 20s | 4h 41m 1s | True | tothman | 0 | "1 tothman May 14, 2020, 12:33:23 AM" | other | 1589403731835 | 1589420592991 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.26.16 | 64 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 21640 | 5 | False | May 12, 2020, 4:46:14 PM | Tue May 12 16:10:00 AST 2020 | 1|198950|198953 | 2 | 1 | 49746 | May 12, 2020, 3:37:46 PM | May 12, 2020, 4:10:00 PM | 1d 23h 29m 33s | 32m 13s | True | aaalghanayem | 2 | "This offense was closed with reason: Non-Issue. aaalghanayem May 12, 2020, 4:46:14 PM" | other | 1589287066937 | 1589289000775 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.26.185 | 3 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 19844 | 2 | False | May 3, 2020, 12:36:02 PM | Sun May 03 08:43:47 AST 2020 | 1 | 2 | 0 | 54331 | May 3, 2020, 7:05:43 AM | May 3, 2020, 8:43:47 AM | 11d 6h 55m 46s | 1h 38m 3s | False | aaalghanayem | 2 | "This offense was closed with reason: Response Completed. aaalghanayem May 3, 2020, 12:36:02 PM" | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | 1588478743397 | 1588484627259 | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | Southern_Region.[NAME].MAH.DataVLAN | 10.49.41.102 | 0 | 1 | 1 | Default Domain
 |  |  |  | Low |  |  | 19845 | 2 | False | May 3, 2020, 1:11:38 PM | Sun May 03 08:43:47 AST 2020 | 1 | 2 | 0 | 54331 | May 3, 2020, 7:05:43 AM | May 3, 2020, 8:43:47 AM | 11d 6h 55m 46s | 1h 38m 3s | False | aaalghanayem | 2 | "This offense was closed with reason: Non-Issue. aaalghanayem May 3, 2020, 1:11:38 PM" | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | 1588478743397 | 1588484627259 | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | Southern_Region.[NAME].MAH.DataVLAN | 10.49.41.102 | 0 | 1 | 1 | Default Domain
 |  |  |  | Low |  |  | 19846 | 2 | False | May 3, 2020, 1:11:38 PM | Sun May 03 07:09:49 AST 2020 | 1 | 2 | 0 | 40731 | May 3, 2020, 7:08:06 AM | May 3, 2020, 7:09:49 AM | 11d 8h 29m 44s | 1m 42s | False | aaalghanayem | 2 | "This offense was closed with reason: Non-Issue. aaalghanayem May 3, 2020, 1:11:38 PM" | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | 1588478886835 | 1588478989027 | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | Central_Region.Riyadh.DC.DataVLAN | 10.169.3.136 | 0 | 1 | 1 | Default Domain
 |  |  |  | Low |  |  | 19848 | 2 | False | May 3, 2020, 2:01:56 PM | Sun May 03 07:10:46 AST 2020 | 1 | 2 | 1 | 54332 | May 3, 2020, 7:09:48 AM | May 3, 2020, 7:10:46 AM | 11d 8h 28m 47s | 57s | False | aaalghanayem | 2 | "This offense was closed with reason: Non-Issue. aaalghanayem May 3, 2020, 2:01:56 PM" | other | 1588478988885 | 1588479046582 | other | other | 169.254.3.13 | 1 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 19849 | 3 | False | May 3, 2020, 1:15:45 PM | Sun May 03 07:10:00 AST 2020 | 1 | 1 | 1 | 54332 | May 3, 2020, 7:10:00 AM | May 3, 2020, 7:10:00 AM | 11d 8h 29m 33s | 0s | False | aaalghanayem | 2 | "This offense was closed with reason: Non-Issue. aaalghanayem May 3, 2020, 1:15:45 PM" | other | 1588479000101 | 1588479000101 | other | other | 169.254.3.13 | 1 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 19852 | 2 | False | May 3, 2020, 1:11:38 PM | Sun May 03 07:44:29 AST 2020 | 1 | 2 | 0 | 44764 | May 3, 2020, 7:44:22 AM | May 3, 2020, 7:44:29 AM | 11d 7h 55m 4s | 7s | False | aaalghanayem | 2 | "This offense was closed with reason: Non-Issue. aaalghanayem May 3, 2020, 1:11:38 PM" | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | 1588481062389 | 1588481069463 | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | Net-10-172-192.Net_10_0_0_0 | 10.169.21.236 | 0 | 1 | 1 | Default Domain
 |  |  |  | Low |  |  | 19870 | 2 | False | May 3, 2020, 8:43:11 PM | Sun May 03 20:38:48 AST 2020 | 1 | 2 | 0 | 54347 | May 3, 2020, 8:31:47 PM | May 3, 2020, 8:38:48 PM | 10d 19h 45s | 7m | False | mfaFreih | 2 | "This offense was closed with reason: Response Completed.  Notes: Non issue  mfaFreih May 3, 2020, 8:43:11 PM" | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | 1588527107484 | 1588527528307 | Central_Region.Riyadh.DC.Server-Farm.PRODAVL1 | Southern_Region.Baha.BRN.DataVLAN | 10.53.71.14 | 0 | 1 | 1 | Default Domain
 |  |  |  | Low |  |  | 20479 | 3 | False | May 6, 2020, 1:34:33 AM | Wed May 06 01:34:08 AST 2020 | 1 | 2 | 1 | 51232 | May 6, 2020, 1:33:38 AM | May 6, 2020, 1:34:08 AM | 8d 14h 5m 25s | 30s | False | adalsultan | 2 | "This offense was closed with reason: Non-Issue. adalsultan May 6, 2020, 1:34:33 AM" | other | 1588718018184 | 1588718048618 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.27.17 | 2 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 20690 | 3 | False | May 7, 2020, 5:58:58 AM | Thu May 07 05:08:52 AST 2020 | 1 | 2 | 2 | 32146 | May 7, 2020, 5:03:04 AM | May 7, 2020, 5:08:52 AM | 7d 10h 30m 41s | 5m 48s | False | adalsultan | 2 | "This offense was closed with reason: Non-Issue. adalsultan May 7, 2020, 5:58:58 AM" | Net-10-172-192.Net_10_0_0_0 | 1588816984578 | 1588817332644 | Multiple (4) | Net-10-172-192.Net_10_0_0_0 | 10.179.26.79 | 44 | 5 | 4 | Default Domain
 |  |  |  | Low |  |  | 20710 | 2 | False | May 7, 2020, 9:35:21 AM | Thu May 07 09:34:31 AST 2020 | 1 | 2 | 1 | 40629 | May 7, 2020, 9:34:30 AM | May 7, 2020, 9:34:31 AM | 7d 6h 5m 2s | 0s | False | abaljebreen | 2 | "This offense was closed with reason: Non-Issue.  Notes: dev42unx abaljebreen May 7, 2020, 9:35:21 AM" | Central_Region.Riyadh.DC.Server-Farm.PRODAVL2 | 1588833270784 | 1588833271187 | Central_Region.Riyadh.DC.Server-Farm.PRODAVL2 | Net-10-172-192.Net_10_0_0_0 | 10.161.3.225 | 0 | 1 | 1 | Default Domain
 |  |  |  | Low |  |  | 20909 | 2 | False | May 8, 2020, 6:00:50 AM | Fri May 08 06:00:28 AST 2020 | 1 | 2 | 0 | 1836 | May 8, 2020, 5:59:25 AM | May 8, 2020, 6:00:28 AM | 6d 9h 39m 5s | 1m 2s | False | adalsultan | 2 | "This offense was closed with reason: Non-Issue. adalsultan May 8, 2020, 6:00:50 AM" | Net-10-172-192.Net_10_0_0_0 | 1588906765592 | 1588906828163 | Net-10-172-192.Net_10_0_0_0 | Net-10-172-192.Net_10_0_0_0 | 10.184.34.33 | 0 | 1 | 1 | Default Domain
 |  |  |  | Low |  |  | 21001 | 2 | False | May 9, 2020, 12:06:02 PM | Sat May 09 06:26:05 AST 2020 | 1 | 2 | 1 | 34809 | May 9, 2020, 6:26:04 AM | May 9, 2020, 6:26:05 AM | 5d 9h 13m 28s | 0s | False | hmirza | 2 | "This offense was closed with reason: Non-Issue. hmirza May 9, 2020, 12:06:02 PM" | other | 1588994764767 | 1588994765725 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.26.86 | 1 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 21003 | 3 | False | May 9, 2020, 11:48:27 AM | Sat May 09 06:57:52 AST 2020 | 1|198071|198074 | 2 | 1 | 48847 | May 9, 2020, 6:26:29 AM | May 9, 2020, 6:57:52 AM | 5d 8h 41m 41s | 31m 23s | False | hmirza | 2 | "This offense was closed with reason: Non-Issue.  Notes: action= blocked hmirza May 9, 2020, 11:48:27 AM" | other | 1588994789180 | 1588996672704 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.26.110 | 24 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 21005 | 3 | False | May 9, 2020, 11:45:54 AM | Sat May 09 08:55:28 AST 2020 | 1|198077 | 2 | 1 | 40705 | May 9, 2020, 8:21:15 AM | May 9, 2020, 8:55:28 AM | 5d 6h 44m 5s | 34m 13s | False | hmirza | 2 | "This offense was closed with reason: Non-Issue.  Notes: action= blocked hmirza May 9, 2020, 11:45:54 AM" | other | 1589001675016 | 1589003728150 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.26.29 | 76 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 21006 | 3 | False | May 9, 2020, 11:45:12 AM | Sat May 09 10:13:31 AST 2020 | 1|198098 | 2 | 1 | 40701 | May 9, 2020, 10:10:07 AM | May 9, 2020, 10:13:31 AM | 5d 5h 26m 2s | 3m 24s | False | hmirza | 2 | "This offense was closed with reason: Non-Issue.  Notes: action= blocked hmirza May 9, 2020, 11:45:12 AM" | other | 1589008207358 | 1589008411668 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.26.24 | 8 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 21008 | 3 | False | May 9, 2020, 11:44:23 AM | Sat May 09 11:22:59 AST 2020 | 1|198103 | 2 | 1 | 40624 | May 9, 2020, 11:17:39 AM | May 9, 2020, 11:22:59 AM | 5d 4h 16m [NAME] | 5m 19s | False | hmirza | 2 | "This offense was closed with reason: Non-Issue.  Notes: action= blocked hmirza May 9, 2020, 11:44:23 AM" | other | 1589012259438 | 1589012579177 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.26.21 | 9 | 0 | 1 | Default Domain
 |  |  |  | Low |  |  | 21011 | 2 | False | May 9, 2020, 11:57:27 AM | Sat May 09 11:57:56 AST 2020 | 1 | 2 | 0 | 75342 | May 9, 2020, 11:54:38 AM | May 9, 2020, 11:57:56 AM | 5d 3h 41m 37s | 3m 18s | False | hmirza | 2 | "This offense was closed with reason: Non-Issue. hmirza May 9, 2020, 11:57:27 AM" | Central_Region.Riyadh.DC.DMZ.PRODUCTION1 | 1589014478064 | 1589014676148 | Multiple (2) | other | 51.36.112.47 | 0 | 4 | 2 | Default Domain
 |  |  |  | Low |  |  | 21012 | 2 | False | May 9, 2020, 12:03:55 PM | Sat May 09 12:03:59 AST 2020 | 1 | 2 | 0 | 75371 | May 9, 2020, 11:57:35 AM | May 9, 2020, 12:03:59 PM | 5d 3h 35m 34s | 6m 24s | False | hmirza | 2 | "This offense was closed with reason: Non-Issue. hmirza May 9, 2020, 12:03:55 PM" | Central_Region.Riyadh.DC.DMZ.PRODUCTION2 | 1589014655666 | 1589015039787 | Multiple (2) | other | 51.36.232.24 | 0 | 6 | 2 | Default Domain
 |  |  |  | Low |  |  | 21027 | 2 | False | May 9, 2020, 5:27:07 PM | Sat May 09 17:26:58 AST 2020 | 1 | 2 | 0 | 80152 | May 9, 2020, 5:23:31 PM | May 9, 2020, 5:26:58 PM | 4d 22h 12m 35s | 3m 26s | False | aaalghanayem | 2 | "This offense was closed with reason: Non-Issue. aaalghanayem May 9, 2020, 5:27:07 PM" | Central_Region.Riyadh.DC.DMZ.PRODUCTION1 | 1589034211164 | 1589034418080 | Multiple (2) | other | 5.156.31.167 | 0 | 5 | 2 | Default Domain
 |  |  |  | Low |  |  | 21028 | 2 | False | May 9, 2020, 5:58:35 PM | Sat May 09 17:32:07 AST 2020 | 1 | 2 | 0 | 80138 | May 9, 2020, 5:27:09 PM | May 9, 2020, 5:32:07 PM | 4d 22h 7m 26s | 4m 58s | False | aaalghanayem | 2 | "This offense was closed with reason: Non-Issue. aaalghanayem May 9, 2020, 5:58:35 PM" | Central_Region.Riyadh.DC.DMZ.PRODUCTION1 | 1589034429570 | 1589034727848 | Multiple (2) | other | 51.223.62.195 | 0 | 4 | 2 | Default Domain
 |  |  |  | Low |  |  | 21083 | 4 | False | May 10, 2020, 8:20:36 AM | Sun May 10 08:17:13 AST 2020 | 1|198192 | 2 | 1 | 32060 | May 10, 2020, 8:15:05 AM | May 10, 2020, 8:17:13 AM | 4d 7h 22m 20s | 2m 7s | False | hmirza | 2 | "This offense was closed with reason: Non-Issue. hmirza May 10, 2020, 8:20:36 AM" | other | 1589087705827 | 1589087833230 | other | Net-10-172-192.Net_10_0_0_0 | 10.179.26.63 | 1 | 0 | 1 | Default Domain