Spreadsheet: 675444d1588290593-calculate-times-book1-razaster-
Sheet: Sheet1

Date | Time | Door | User | Action | Time2
2020-02-11 00:00:00 | 12:48:59 | GGH_Ground_Floor_North_Kitchen_In | A.Person1 | ALLOW |  |  |  | User | Sum of Time2
2020-02-11 00:00:00 | 12:50:33 | GGH_Ground_Floor_North_Kitchen_Out | A.Person1 | ALLOW |  |  |  | A.Person1 | 00:26:40
2020-02-11 00:00:00 | 12:55:32 | GGH_Ground_Floor_North_Kitchen_Out | A.Person2 | ALLOW |  |  |  | A.Person10 | 00:00:00
2020-02-11 00:00:00 | 12:55:44 | GGH_Rotunda_Front_Outer_Out | A.Person3 | ALLOW |  |  |  | A.Person11 | 00:19:47
2020-02-11 00:00:00 | 12:59:23 | GGH_Rotunda_Front_Outer_In | A.Person4 | ALLOW |  |  |  | A.Person12 | 01:16:21
2020-02-11 00:00:00 | 13:13:16 | GGH_Ground_Floor_North_Kitchen_In | A.Person5 | ALLOW |  |  |  | A.Person13 | 00:00:00
2020-02-11 00:00:00 | 13:17:36 | GGH_Ground_Floor_North_Kitchen_Out | A.Person5 | ALLOW |  |  |  | [NAME] | 00:00:00
2020-02-11 00:00:00 | 13:32:09 | GGH_Ground_Floor_North_Kitchen_In | A.Person6 | ALLOW |  |  |  | A.Person15 | 00:00:00
2020-02-11 00:00:00 | 13:32:29 | GGH_Ground_Floor_North_Kitchen_Out | A.Person7 | ALLOW |  |  |  | A.Person16 | 00:04:52
2020-02-11 00:00:00 | 13:34:21 | GGH_Ground_Floor_North_Kitchen_In | A.Person8 | ALLOW |  |  |  | A.Person17 | 00:00:00
2020-02-11 00:00:00 | 13:34:49 | GGH_Ground_Floor_North_Kitchen_In | A.Person7 | ALLOW |  |  |  | [NAME] | 00:00:00
2020-02-11 00:00:00 | 13:35:58 | GGH_Ground_Floor_North_Kitchen_Out | A.Person7 | ALLOW |  |  |  | A.Person19 | 00:00:00
2020-02-11 00:00:00 | 13:40:48 | GGH_Ground_Floor_North_Kitchen_In | A.Person1 | ALLOW |  |  |  | A.Person2 | 00:00:00
2020-02-11 00:00:00 | 13:42:23 | GGH_Ground_Floor_North_Kitchen_Out | A.Person9 | ALLOW |  |  |  | A.Person20 | 00:00:00
2020-02-11 00:00:00 | 13:44:07 | GGH_Ground_Floor_North_Kitchen_Out | A.Person10 | ALLOW |  |  |  | A.Person21 | 00:00:00
2020-02-11 00:00:00 | 13:46:16 | GGH_Ground_Floor_North_Kitchen_Out | A.Person1 | ALLOW |  |  |  | [NAME] | 00:00:00
2020-02-11 00:00:00 | 13:51:08 | GGH_Rotunda_Front_Outer_Out | A.Person11 | ALLOW |  |  |  | A.Person23 | 00:00:00
2020-02-11 00:00:00 | 13:56:54 | GGH_Ground_Floor_North_Kitchen_In | A.Person12 | ALLOW |  |  |  | [NAME] | 00:00:00
2020-02-11 00:00:00 | 13:57:32 | GGH_Ground_Floor_North_Kitchen_Out | A.Person12 | ALLOW |  |  |  | A.Person25 | 00:00:00
2020-02-11 00:00:00 | 13:59:06 | GGH_Ground_Floor_North_Kitchen_In | A.Person12 | ALLOW |  |  |  | A.Person26 | 00:00:04
2020-02-11 00:00:00 | 14:01:56 | GGH_Ground_Floor_North_Kitchen_Out | A.Person8 | ALLOW |  |  |  | A.Person3 | 00:00:00
2020-02-11 00:00:00 | 14:10:55 | GGH_Rotunda_Front_Outer_Out | A.Person11 | ALLOW |  |  |  | A.Person4 | 00:00:00
2020-02-11 00:00:00 | 14:28:02 | GGH_Ground_Floor_North_Kitchen_In | A.Person5 | ALLOW |  |  |  | A.Person5 | 00:06:08
2020-02-11 00:00:00 | 14:29:50 | GGH_Ground_Floor_North_Kitchen_Out | A.Person5 | ALLOW |  |  |  | A.Person6 | 00:02:50
2020-02-11 00:00:00 | 14:38:11 | GGH_Ground_Floor_North_Kitchen_Out | A.Person13 | ALLOW |  |  |  | A.Person7 | 00:01:09
2020-02-11 00:00:00 | 14:41:11 | GGH_Ground_Floor_North_Kitchen_In | A.Person13 | ALLOW |  |  |  | A.Person8 | 00:27:35
2020-02-11 00:00:00 | 14:44:57 | GGH_Ground_Floor_North_Kitchen_Out | [NAME] | ALLOW |  |  |  | A.Person9 | 00:00:00
2020-02-11 00:00:00 | 15:05:08 | GGH_Ground_Floor_North_Kitchen_In | A.Person10 | ALLOW |  |  |  | Temp Visitor | 00:00:00
2020-02-11 00:00:00 | 15:14:49 | GGH_Ground_Floor_North_Kitchen_Out | A.Person12 | ALLOW |  |  |  | Grand Total | 02:45:26
2020-02-11 00:00:00 | 15:15:23 | GGH_Ground_Floor_North_Kitchen_In | A.Person7 | ALLOW
2020-02-11 00:00:00 | 15:18:31 | GGH_Ground_Floor_North_Kitchen_Out | A.Person15 | ALLOW
2020-02-11 00:00:00 | 15:21:59 | GGH_Ground_Floor_North_Kitchen_In | A.Person16 | ALLOW
2020-02-11 00:00:00 | 15:23:36 | GGH_Ground_Floor_North_Kitchen_Out | A.Person16 | ALLOW
2020-02-11 00:00:00 | 15:24:22 | GGH_Ground_Floor_North_Kitchen_Out | A.Person17 | ALLOW
2020-02-11 00:00:00 | 15:26:53 | GGH_Ground_Floor_North_Kitchen_Out | [NAME] | ALLOW
2020-02-11 00:00:00 | 15:30:28 | GGH_Ground_Floor_North_Kitchen_In | A.Person17 | ALLOW
2020-02-11 00:00:00 | 15:31:04 | GGH_Ground_Floor_North_Kitchen_In | A.Person1 | ALLOW
2020-02-11 00:00:00 | 15:31:32 | GGH_Ground_Floor_North_Kitchen_In | A.Person6 | ALLOW
2020-02-11 00:00:00 | 15:34:22 | GGH_Ground_Floor_North_Kitchen_Out | A.Person6 | ALLOW
2020-02-11 00:00:00 | 15:45:05 | GGH_Ground_Floor_North_Kitchen_Out | A.Person19 | ALLOW
2020-02-11 00:00:00 | 15:46:16 | GGH_Ground_Floor_North_Kitchen_Out | Temp Visitor | ALLOW
2020-02-11 00:00:00 | 15:48:58 | GGH_Ground_Floor_North_Kitchen_Out | A.Person1 | ALLOW
2020-02-11 00:00:00 | 15:52:41 | GGH_Ground_Floor_North_Kitchen_In | A.Person5 | ALLOW
2020-02-11 00:00:00 | 15:53:38 | GGH_Ground_Floor_North_Kitchen_Out | A.Person20 | ALLOW
2020-02-11 00:00:00 | 15:54:45 | GGH_Ground_Floor_North_Kitchen_In | A.Person20 | ALLOW
2020-02-11 00:00:00 | 15:55:41 | GGH_Ground_Floor_North_Kitchen_Out | A.Person21 | ALLOW
2020-02-11 00:00:00 | 15:56:14 | GGH_Ground_Floor_North_Kitchen_In | A.Person21 | ALLOW
2020-02-11 00:00:00 | 15:58:20 | GGH_Ground_Floor_North_Kitchen_Out | [NAME] | ALLOW
2020-02-11 00:00:00 | 15:59:35 | GGH_Ground_Floor_North_Kitchen_In | A.Person1 | ALLOW
2020-02-11 00:00:00 | 16:00:18 | GGH_Ground_Floor_North_Kitchen_In | A.Person16 | ALLOW
2020-02-11 00:00:00 | 16:03:33 | GGH_Ground_Floor_North_Kitchen_Out | A.Person16 | ALLOW
2020-02-11 00:00:00 | 16:04:08 | GGH_Ground_Floor_North_Kitchen_In | A.Person23 | ALLOW
2020-02-11 00:00:00 | 16:04:35 | GGH_Rotunda_Front_Outer_In | [NAME] | ALLOW
2020-02-11 00:00:00 | 16:09:38 | GGH_Ground_Floor_North_Kitchen_In | A.Person2 | ALLOW
2020-02-11 00:00:00 | 16:20:36 | GGH_Ground_Floor_North_Kitchen_In | A.Person7 | ALLOW
2020-02-11 00:00:00 | 16:21:56 | GGH_Ground_Floor_North_Kitchen_Out | A.Person25 | ALLOW
2020-02-11 00:00:00 | 16:22:10 | GGH_Ground_Floor_North_Kitchen_In | A.Person1 | ALLOW
2020-02-11 00:00:00 | 16:23:54 | GGH_Ground_Floor_North_Kitchen_Out | A.Person1 | ALLOW
2020-02-11 00:00:00 | 19:08:20 | GGH_Rotunda_Front_Outer_In | A.Person26 | ALLOW
2020-02-11 00:00:00 | 19:08:24 | GGH_Rotunda_Front_Outer_Out | A.Person26 | ALLOW