Spreadsheet: 869865d1716406252-capture-login-logout-powerquery-help-login-logout-time-stamp_ck
Sheet: Login Logout

As is |  |  |  |  | Expected Result
User ID | agent | presence_state | Time Stamp |  | User ID | agent | presence_state | Login | Logout | [NAME]
1234 | Aman | Available | 2024-05-17 19:01:00 |  | 1234 | Aman | Available | 2024-05-17 19:01:00 | 2024-05-17 22:56:12 | 2024-05-17 00:00:00
1234 | Aman | Away | 2024-05-17 22:56:12 |  | 1234 | Aman | Away | 2024-05-17 22:56:12 | 2024-05-17 23:02:34 | 2024-05-17 00:00:00
1234 | Aman | Available | 2024-05-17 23:02:34 |  | 1234 | Aman | Available | 2024-05-17 23:02:34 | 2024-05-18 00:09:01 | 2024-05-17 00:00:00
1234 | Aman | Busy | 2024-05-18 00:09:01 |  | 1234 | Aman | Busy | 2024-05-18 00:09:01 | 2024-05-18 00:17:28 | 2024-05-17 00:00:00
1234 | Aman | Available | 2024-05-18 00:17:28 |  | 1234 | Aman | Available | 2024-05-18 00:17:28 | 2024-05-18 03:52:07 | 2024-05-17 00:00:00
1234 | Aman | Away | 2024-05-18 03:52:07 |  | 1234 | Aman | Away | 2024-05-18 03:52:07 | 2024-05-18 04:00:33 | 2024-05-17 00:00:00
1234 | Aman | Offline | 2024-05-18 04:00:33 |  | 1234 | Aman | Offline | 2024-05-18 04:00:33 |  | 2024-05-17 00:00:00
7890 | Anas | Available | 2024-05-17 07:04:29 |  | 7890 | Anas | Available | 2024-05-17 07:04:29 | 2024-05-17 08:20:08 | 2024-05-17 00:00:00
7890 | Anas | Away | 2024-05-17 08:20:08 |  | 7890 | Anas | Away | 2024-05-17 08:20:08 | 2024-05-17 08:23:03 | 2024-05-17 00:00:00
7890 | Anas | Available | 2024-05-17 08:23:03 |  | 7890 | Anas | Available | 2024-05-17 08:23:03 | 2024-05-17 08:23:07 | 2024-05-17 00:00:00
7890 | Anas | Offline | 2024-05-17 08:23:07 |  | 7890 | Anas | Offline | 2024-05-17 08:23:07 | 2024-05-17 11:50:34 | 2024-05-17 00:00:00
7890 | Anas | Available | 2024-05-17 11:50:34 |  | 7890 | Anas | Available | 2024-05-17 11:50:34 | 2024-05-17 12:57:21 | 2024-05-17 00:00:00
7890 | Anas | Offline | 2024-05-17 12:57:21 |  | 7890 | Anas | Offline | 2024-05-17 12:57:21 | 2024-05-17 13:07:34 | 2024-05-17 00:00:00
7890 | Anas | Away | 2024-05-17 13:07:34 |  | 7890 | Anas | Away | 2024-05-17 13:07:34 | 2024-05-17 14:02:27 | 2024-05-17 00:00:00
7890 | Anas | Available | 2024-05-17 14:02:27 |  | 7890 | Anas | Available | 2024-05-17 14:02:27 | 2024-05-17 15:03:04 | 2024-05-17 00:00:00
7890 | Anas | Away | 2024-05-17 15:03:04 |  | 7890 | Anas | Away | 2024-05-17 15:03:04 | 2024-05-17 15:25:13 | 2024-05-17 00:00:00
7890 | Anas | Available | 2024-05-17 15:25:13 |  | 7890 | Anas | Available | 2024-05-17 15:25:13 | 2024-05-17 15:50:40 | 2024-05-17 00:00:00
7890 | Anas | Offline | 2024-05-17 15:50:40 |  | 7890 | Anas | Offline | 2024-05-17 15:50:40 |  | 2024-05-17 00:00:00
5678 | [NAME] | Available | 2024-05-17 08:20:30 |  | 5678 | [NAME] | Available | 2024-05-17 08:20:30 | 2024-05-17 09:31:29 | 2024-05-17 00:00:00
5678 | [NAME] | Away | 2024-05-17 09:31:29 |  | 5678 | [NAME] | Away | 2024-05-17 09:31:29 | 2024-05-17 09:46:32 | 2024-05-17 00:00:00
5678 | [NAME] | Available | 2024-05-17 09:46:32 |  | 5678 | [NAME] | Available | 2024-05-17 09:46:32 | 2024-05-17 13:01:29 | 2024-05-17 00:00:00
5678 | [NAME] | Away | 2024-05-17 13:01:29 |  | 5678 | [NAME] | Away | 2024-05-17 13:01:29 | 2024-05-17 13:31:43 | 2024-05-17 00:00:00
5678 | [NAME] | Available | 2024-05-17 13:31:43 |  | 5678 | [NAME] | Available | 2024-05-17 13:31:43 | 2024-05-17 15:13:51 | 2024-05-17 00:00:00
5678 | [NAME] | Away | 2024-05-17 15:13:51 |  | 5678 | [NAME] | Away | 2024-05-17 15:13:51 | 2024-05-17 16:20:26 | 2024-05-17 00:00:00
5678 | [NAME] | Available | 2024-05-17 16:20:26 |  | 5678 | [NAME] | Available | 2024-05-17 16:20:26 | 2024-05-17 16:30:04 | 2024-05-17 00:00:00
5678 | [NAME] | Offline | 2024-05-17 16:30:04 |  | 5678 | [NAME] | Offline | 2024-05-17 16:30:04 |  | 2024-05-17 00:00:00
9121 | Hema | Available | 2024-05-17 18:13:33 |  | 9121 | Hema | Available | 2024-05-17 18:13:33 | 2024-05-17 18:32:11 | 2024-05-17 00:00:00
9121 | Hema | Offline | 2024-05-17 18:32:11 |  | 9121 | Hema | Offline | 2024-05-17 18:32:11 | 2024-05-17 18:35:13 | 2024-05-17 00:00:00
9121 | Hema | Available | 2024-05-17 18:35:13 |  | 9121 | Hema | Available | 2024-05-17 18:35:13 | 2024-05-17 19:00:03 | 2024-05-17 00:00:00
9121 | Hema | Offline | 2024-05-17 19:00:03 |  | 9121 | Hema | Offline | 2024-05-17 19:00:03 | 2024-05-17 19:01:00 | 2024-05-17 00:00:00
9121 | Hema | Available | 2024-05-17 19:01:00 |  | 9121 | Hema | Available | 2024-05-17 19:01:00 | 2024-05-17 22:56:12 | 2024-05-17 00:00:00
9121 | Hema | Away | 2024-05-17 22:56:12 |  | 9121 | Hema | Away | 2024-05-17 22:56:12 | 2024-05-17 23:02:34 | 2024-05-17 00:00:00
9121 | Hema | Available | 2024-05-17 23:02:34 |  | 9121 | Hema | Available | 2024-05-17 23:02:34 | 2024-05-18 00:02:34 | 2024-05-17 00:00:00
9121 | Hema | Away | 2024-05-18 00:02:34 |  | 9121 | Hema | Away | 2024-05-18 00:02:34 | 2024-05-18 01:02:34 | 2024-05-17 00:00:00
9121 | Hema | Offline | 2024-05-18 01:02:34 |  | 9121 | Hema | Offline | 2024-05-18 01:02:34 | 2024-05-18 02:05:34 | 2024-05-17 00:00:00
9121 | Hema | Available | 2024-05-18 02:05:34 |  | 9121 | Hema | Available | 2024-05-18 02:05:34 | 2024-05-18 03:02:34 | 2024-05-17 00:00:00
9121 | Hema | Offline | 2024-05-18 03:02:34 |  | 9121 | Hema | Offline | 2024-05-18 03:02:34 |  | 2024-05-17 00:00:00
9121 | Hema | Available | 2024-05-18 13:01:29 |  | 9121 | Hema | Available | 2024-05-18 13:01:29 | 2024-05-18 13:31:43 | 2024-05-18 00:00:00
9121 | Hema | Offline | 2024-05-18 13:31:43 |  | 9121 | Hema | Offline | 2024-05-18 13:31:43 | 2024-05-18 15:13:51 | 2024-05-18 00:00:00
9121 | Hema | Available | 2024-05-18 15:13:51 |  | 9121 | Hema | Available | 2024-05-18 15:13:51 | 2024-05-18 16:20:26 | 2024-05-18 00:00:00
9121 | Hema | Offline | 2024-05-18 16:20:26 |  | 9121 | Hema | Offline | 2024-05-18 16:20:26 | 2024-05-18 16:30:04 | 2024-05-18 00:00:00
9121 | Hema | Available | 2024-05-18 16:30:04 |  | 9121 | Hema | Available | 2024-05-18 16:30:04 | 2024-05-18 22:56:12 | 2024-05-18 00:00:00
9121 | Hema | Away | 2024-05-18 22:56:12 |  | 9121 | Hema | Away | 2024-05-18 22:56:12 | 2024-05-18 23:02:34 | 2024-05-18 00:00:00
9121 | Hema | Offline | 2024-05-18 23:02:34 |  | 9121 | Hema | Offline | 2024-05-18 23:02:34 |  | 2024-05-18 00:00:00