Spreadsheet: 723283d1615601746-system-generate-user-remote-want-to-total-daily-hours-logged-on-duration-report-with-multiple-log-ins-and-log-outs-plus-disconnects-derek-b-
Sheet: Time Extracted

[NAME] | Event Date | Activity | Server | [NAME] | Time Extracted | Duration
User4 | 2021-02-22 08:02:00 | Active | 001RDSH044 | LAPTOP-V4I7
User4 | 2021-02-22 08:11:00 | Logged Off | 001RDSH044 | LAPTOP-V4I7 |  |  |  | Days | [NAME] | Sum of Duration
User1 | 2021-02-22 08:48:00 | Active | 001RDSH049 | DESKTOP-9DK |  |  |  | 22-Feb | User1 | 08:15:00
User3 | 2021-02-22 08:58:00 | Active | 001RDSH050 | DESKTOP-P0B |  |  |  |  | User2 | 03:02:00
User2 | 2021-02-22 08:58:00 | Active | 001RDSH040 | DESKTOP-N5M |  |  |  |  | User3 | 08:06:00
[NAME] | 2021-02-22 09:00:00 | Active | 001RDSH045 | LAPTOP-C5R1 |  |  |  |  | User4 | 02:24:00
User3 | 2021-02-22 09:04:00 | Disconnected | 001RDSH050 | DESKTOP-P0B |  |  |  |  | [NAME] | 08:56:00
User3 | 2021-02-22 09:04:00 | Active | 001RDSH050 | DESKTOP-P0B |  |  |  | 23-Feb | User1 | 08:13:00
User3 | 2021-02-22 09:04:00 | Active | 001RDSH050 | DESKTOP-P0B |  |  |  |  | User2 | 07:40:00
User3 | 2021-02-22 09:04:00 | Active | 001RDSH050 | DESKTOP-P0B |  |  |  |  | User3 | 08:08:00
User4 | 2021-02-22 09:47:00 | Active | 001RDSH041 | LAPTOP-V4I7 |  |  |  |  | User4 | 07:22:00
User4 | 2021-02-22 11:39:00 | Logged Off | 001RDSH041 | LAPTOP-V4I7 |  |  |  |  | [NAME] | 08:28:00
User2 | 2021-02-22 14:00:00 | Active | 001RDSH040 | DESKTOP-N5M |  |  |  | 24-Feb | User1 | 08:07:00
User2 | 2021-02-22 14:01:00 | Disconnected | 001RDSH040 | DESKTOP-N5M |  |  |  |  | User2 | 09:23:00
User2 | 2021-02-22 14:02:00 | Active | 001RDSH040 | DESKTOP-N5M |  |  |  |  | User3 | 08:03:00
User2 | 2021-02-22 14:02:00 | Active | 001RDSH040 | DESKTOP-N5M |  |  |  |  | User4 | 02:49:00
User1 | 2021-02-22 17:03:00 | Logged Off | 001RDSH049 | DESKTOP-9DK |  |  |  |  | [NAME] | 07:30:00
User2 | 2021-02-22 17:03:00 | Logged Off | 001RDSH040 | DESKTOP-N5M |  |  |  | 25-Feb | User1 | 08:14:00
User3 | 2021-02-22 17:04:00 | Logged Off | 001RDSH050 | DESKTOP-P0B |  |  |  |  | User2 | 07:42:00
[NAME] | 2021-02-22 17:51:00 | Disconnected | 001RDSH045 | LAPTOP-C5R1 |  |  |  |  | User3 | 08:00:00
[NAME] | 2021-02-22 17:51:00 | Disconnected | 001RDSH045 | LAPTOP-C5R1 |  |  |  |  | User4 | 10:01:00
[NAME] | 2021-02-22 17:56:00 | Logged Off | 001RDSH045 | LAPTOP-C5R1 |  |  |  |  | [NAME] | 07:05:00
User4 | 2021-02-22 21:07:00 | Active | 001RDSH041 | LAPTOP-V4I7 |  |  |  | 26-Feb | User1 | 08:20:00
User4 | 2021-02-22 21:30:00 | Logged Off | 001RDSH041 | LAPTOP-V4I7 |  |  |  |  | User3 | 08:01:00
User1 | 2021-02-23 08:52:00 | Active | 001RDSH042 | DESKTOP-JDM |  |  |  |  | User4 | 00:05:00
User2 | 2021-02-23 08:54:00 | Active | 001RDSH049 | DESKTOP-N5M |  |  |  |  | [NAME] | 03:20:00
User2 | 2021-02-23 09:00:00 | Disconnected | 001RDSH049 | DESKTOP-N5M
User2 | 2021-02-23 09:00:00 | Disconnected | 001RDSH049 | DESKTOP-N5M
User3 | 2021-02-23 09:00:00 | Active | 001RDSH042 | DESKTOP-P0B
User2 | 2021-02-23 09:05:00 | Active | 001RDSH049 | DESKTOP-N5M
User2 | 2021-02-23 09:05:00 | Logged Off | 001RDSH049 | DESKTOP-N5M
User2 | 2021-02-23 09:07:00 | Active | 001RDSH041 | DESKTOP-N5M
[NAME] | 2021-02-23 09:25:00 | Active | 001RDSH043 | LAPTOP-C5R1
User4 | 2021-02-23 09:42:00 | Active | 001RDSH048 | LAPTOP-V4I7
User1 | 2021-02-23 09:49:00 | Logged Off | 001RDSH042 | DESKTOP-JDM
User1 | 2021-02-23 09:52:00 | Active | 001RDSH048 | DESKTOP-JDM
User2 | 2021-02-23 13:26:00 | Disconnected | 001RDSH041 | DESKTOP-N5M
User2 | 2021-02-23 13:26:00 | Disconnected | 001RDSH041 | DESKTOP-N5M
User2 | 2021-02-23 13:31:00 | Logged Off | 001RDSH041 | DESKTOP-N5M
User2 | 2021-02-23 14:02:00 | Active | 001RDSH042 | DESKTOP-N5M
User1 | 2021-02-23 14:20:00 | Disconnected | 001RDSH048 | DESKTOP-JDM
User1 | 2021-02-23 14:20:00 | Active | 001RDSH048 | LAPTOP-NLOS
User1 | 2021-02-23 14:20:00 | Active | 001RDSH048 | LAPTOP-NLOS
User1 | 2021-02-23 14:20:00 | Active | 001RDSH048 | LAPTOP-NLOS
User1 | 2021-02-23 14:30:00 | Disconnected | 001RDSH048 | LAPTOP-NLOS
User1 | 2021-02-23 14:30:00 | Disconnected | 001RDSH048 | LAPTOP-NLOS
User1 | 2021-02-23 14:30:00 | Active | 001RDSH048 | DESKTOP-JDM
User1 | 2021-02-23 14:30:00 | Active | 001RDSH048 | DESKTOP-JDM
User4 | 2021-02-23 17:04:00 | Logged Off | 001RDSH048 | LAPTOP-V4I7
User1 | 2021-02-23 17:08:00 | Logged Off | 001RDSH048 | DESKTOP-JDM
User3 | 2021-02-23 17:08:00 | Logged Off | 001RDSH042 | DESKTOP-P0B
User2 | 2021-02-23 17:12:00 | Logged Off | 001RDSH042 | DESKTOP-N5M
[NAME] | 2021-02-23 17:48:00 | Disconnected | 001RDSH043 | LAPTOP-C5R1
[NAME] | 2021-02-23 17:48:00 | Disconnected | 001RDSH043 | LAPTOP-C5R1
[NAME] | 2021-02-23 17:53:00 | Logged Off | 001RDSH043 | LAPTOP-C5R1
User4 | 2021-02-24 07:44:00 | Connected | 001RDSH040 | LAPTOP-V4I7
User4 | 2021-02-24 07:44:00 | Active | 001RDSH040 | LAPTOP-V4I7
User2 | 2021-02-24 08:54:00 | Active | 001RDSH041 | DESKTOP-N5M
User1 | 2021-02-24 09:02:00 | Active | 001RDSH040 | DESKTOP-JDM
User3 | 2021-02-24 09:02:00 | Active | 001RDSH044 | DESKTOP-P0B
[NAME] | 2021-02-24 10:28:00 | Active | 001RDSH045 | LAPTOP-C5R1
User2 | 2021-02-24 10:59:00 | Disconnected | 001RDSH041 | DESKTOP-N5M
User2 | 2021-02-24 10:59:00 | Disconnected | 001RDSH041 | DESKTOP-N5M
User2 | 2021-02-24 11:04:00 | Logged Off | 001RDSH041 | DESKTOP-N5M
User2 | 2021-02-24 11:10:00 | Active | 001RDSH046 | DESKTOP-N5M
User4 | 2021-02-24 14:25:00 | Active | 001RDSH040 | LAPTOP-V4I7
User4 | 2021-02-24 14:36:00 | Disconnected | 001RDSH040 | LAPTOP-V4I7
User4 | 2021-02-24 14:36:00 | Active | 001RDSH040 | LAPTOP-V4I7
User4 | 2021-02-24 14:36:00 | Active | 001RDSH040 | LAPTOP-V4I7
User3 | 2021-02-24 17:05:00 | Logged Off | 001RDSH044 | DESKTOP-P0B
User1 | 2021-02-24 17:09:00 | Logged Off | 001RDSH040 | DESKTOP-JDM
User4 | 2021-02-24 17:12:00 | Logged Off | 001RDSH040 | LAPTOP-V4I7
User4 | 2021-02-24 17:13:00 | Active | 001RDSH041 | LAPTOP-V4I7
User4 | 2021-02-24 17:15:00 | Logged Off | 001RDSH041 | LAPTOP-V4I7
[NAME] | 2021-02-24 17:53:00 | Disconnected | 001RDSH045 | LAPTOP-C5R1
[NAME] | 2021-02-24 17:53:00 | Disconnected | 001RDSH045 | LAPTOP-C5R1
[NAME] | 2021-02-24 17:58:00 | Logged Off | 001RDSH045 | LAPTOP-C5R1
User2 | 2021-02-24 18:17:00 | Logged Off | 001RDSH046 | DESKTOP-N5M
User2 | 2021-02-24 18:19:00 | Active | 001RDSH040 | DESKTOP-N5M
User2 | 2021-02-24 18:25:00 | Logged Off | 001RDSH040 | DESKTOP-N5M
User4 | 2021-02-25 07:17:00 | Active | 001RDSH043 | LAPTOP-V4I7
User1 | 2021-02-25 08:50:00 | Active | 001RDSH046 | DESKTOP-JDM
User2 | 2021-02-25 09:00:00 | Active | 001RDSH049 | DESKTOP-N5M
User3 | 2021-02-25 09:01:00 | Active | 001RDSH042 | DESKTOP-P0B
[NAME] | 2021-02-25 10:06:00 | Active | 001RDSH042 | LAPTOP-C5R1
User3 | 2021-02-25 10:14:00 | Disconnected | 001RDSH042 | DESKTOP-P0B
User3 | 2021-02-25 10:14:00 | Disconnected | 001RDSH042 | DESKTOP-P0B
User3 | 2021-02-25 10:14:00 | Active | 001RDSH042 | DESKTOP-P0B
User3 | 2021-02-25 10:14:00 | Active | 001RDSH042 | DESKTOP-P0B
User1 | 2021-02-25 10:26:00 | Logged Off | 001RDSH046 | DESKTOP-JDM
User1 | 2021-02-25 10:28:00 | Active | 001RDSH041 | DESKTOP-JDM
User2 | 2021-02-25 11:23:00 | Disconnected | 001RDSH049 | DESKTOP-N5M
User2 | 2021-02-25 11:23:00 | Active | 001RDSH049 | DESKTOP-N5M
User2 | 2021-02-25 11:23:00 | Active | 001RDSH049 | DESKTOP-N5M
User2 | 2021-02-25 11:23:00 | Active | 001RDSH049 | DESKTOP-N5M
[NAME] | 2021-02-25 13:22:00 | Disconnected | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-25 13:22:00 | Disconnected | 001RDSH042 | LAPTOP-C5R1
User2 | 2021-02-25 13:22:00 | Disconnected | 001RDSH049 | DESKTOP-N5M
User2 | 2021-02-25 13:22:00 | Disconnected | 001RDSH049 | DESKTOP-N5M
[NAME] | 2021-02-25 13:27:00 | Logged Off | 001RDSH042 | LAPTOP-C5R1
User2 | 2021-02-25 13:27:00 | Logged Off | 001RDSH049 | DESKTOP-N5M
[NAME] | 2021-02-25 13:40:00 | Active | 001RDSH047 | LAPTOP-C5R1
User2 | 2021-02-25 14:04:00 | Active | 001RDSH048 | DESKTOP-N5M
User3 | 2021-02-25 17:01:00 | Logged Off | 001RDSH042 | DESKTOP-P0B
User1 | 2021-02-25 17:06:00 | Logged Off | 001RDSH041 | DESKTOP-JDM
User4 | 2021-02-25 17:18:00 | Logged Off | 001RDSH043 | LAPTOP-V4I7
User2 | 2021-02-25 17:19:00 | Logged Off | 001RDSH048 | DESKTOP-N5M
[NAME] | 2021-02-25 17:19:00 | Disconnected | 001RDSH047 | LAPTOP-C5R1
[NAME] | 2021-02-25 17:19:00 | Disconnected | 001RDSH047 | LAPTOP-C5R1
[NAME] | 2021-02-25 17:24:00 | Logged Off | 001RDSH047 | LAPTOP-C5R1
User1 | 2021-02-26 08:46:00 | Active | 001RDSH040 | DESKTOP-JDM
User3 | 2021-02-26 09:01:00 | Active | 001RDSH041 | DESKTOP-P0B
[NAME] | 2021-02-26 09:02:00 | Active | 001RDSH042 | LAPTOP-C5R1
User1 | 2021-02-26 09:45:00 | Logged Off | 001RDSH040 | DESKTOP-JDM
User1 | 2021-02-26 09:46:00 | Active | 001RDSH045 | DESKTOP-JDM
User4 | 2021-02-26 10:18:00 | Active | 001RDSH048 | LAPTOP-V4I7
User4 | 2021-02-26 10:23:00 | Logged Off | 001RDSH048 | LAPTOP-V4I7
[NAME] | 2021-02-26 12:47:00 | Active | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-26 12:50:00 | Disconnected | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-26 12:50:00 | Active | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-26 12:50:00 | Active | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-26 13:50:00 | Active | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-26 13:54:00 | Disconnected | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-26 13:55:00 | Active | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-26 13:55:00 | Active | 001RDSH042 | LAPTOP-C5R1
User3 | 2021-02-26 14:28:00 | Disconnected | 001RDSH041 | DESKTOP-P0B
User3 | 2021-02-26 14:28:00 | Disconnected | 001RDSH041 | DESKTOP-P0B
User3 | 2021-02-26 14:28:00 | Active | 001RDSH041 | DESKTOP-P0B
User3 | 2021-02-26 14:28:00 | Active | 001RDSH041 | DESKTOP-P0B
User3 | 2021-02-26 17:02:00 | Logged Off | 001RDSH041 | DESKTOP-P0B
[NAME] | 2021-02-26 17:03:00 | Disconnected | 001RDSH042 | LAPTOP-C5R1
[NAME] | 2021-02-26 17:03:00 | Disconnected | 001RDSH042 | LAPTOP-C5R1
User1 | 2021-02-26 17:07:00 | Logged Off | 001RDSH045 | DESKTOP-JDM
[NAME] | 2021-02-26 17:08:00 | Logged Off | 001RDSH042 | LAPTOP-C5R1