Spreadsheet: 863567d1711005195-call-center-login-logout-report-agenttimecard-jt
Sheet: After

Team Name | Team ID | Agent Name | Agent ID | Agent Session | [NAME] | Logout Date | Duration |  | M Code:
AP_ASIA ENGLISH_FILIPINO | 7756407 | Aguas, [NAME] | 39670559 | [PHONE] | 2024-03-18 22:42:04.553000 | 2024-03-19 01:01:56.553000 | 02:19:52 |  | let
AP_ASIA ENGLISH_FILIPINO | 7756407 | Briones, [NAME] | 39670537 | [PHONE] | 2024-03-18 22:44:39.900000 | 2024-03-19 01:03:21.900000 | 02:18:42 |  | Source = Excel.CurrentWorkbook(){[Name="Report"]}[Content],
AP_ASIA ENGLISH_FILIPINO | 7756407 | Galindo, Paolo | 39670568 | [PHONE] | 2024-03-19 22:39:23.407000 | 2024-03-20 00:24:17.407000 | 01:44:54 |  | #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
AP_ASIA ENGLISH_FILIPINO | 7756407 | [NAME], [NAME] | 39670563 | [PHONE] | 2024-03-18 22:41:03.143000 | 2024-03-19 01:01:46.143000 | 02:20:43 |  | #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Team Name (ID)", type text}, {"Agent Name (ID)", type text}, {"Agent Session", type any}, {"Login Date", type datetime}, {"Logout Date", type datetime}, {"Duration", type text}}),
AP_ASIA ENGLISH_FILIPINO | 7756407 | [NAME], [NAME] | 39670540 | [PHONE] | 2024-03-19 22:40:20.993000 | 2024-03-19 22:41:24.993000 | 00:01:04 |  | #"Filled Down" = Table.FillDown(#"Changed Type",{"Team Name (ID)", "Agent Name (ID)"}),
AP_ASIA ENGLISH_FILIPINO | 7756407 | [NAME], [NAME] | 39670540 | [PHONE] | 2024-03-19 22:42:30.073000 | 2024-03-20 00:40:34.073000 | 01:58:04 |  | #"Filtered Rows" = Table.SelectRows(#"Filled [NAME]", each ([Login Date] <> null)),
AP_ASIA ENGLISH_FILIPINO | 7756407 | Nazarro, Victoria | 39670589 | [PHONE] | 2024-03-19 22:39:24.020000 | 2024-03-19 22:41:31.020000 | 00:02:07 |  | #"Changed Type1" = Table.TransformColumnTypes(#"Filtered Rows",{{"Agent Session", type text}}),
AP_ASIA ENGLISH_FILIPINO | 7756407 | Nazarro, Victoria | 39670589 | [PHONE] | 2024-03-19 22:43:25.410000 | 2024-03-20 02:45:23.410000 | 04:01:58 |  | #"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Duration"}),
AP_BAHASA | 7756406 | Lopez, [NAME] | 39670541 | [PHONE] | 2024-03-18 22:43:14.620000 | 2024-03-19 02:41:27.620000 | 03:58:13 |  | #"Inserted Time Subtraction" = Table.AddColumn(#"Removed Columns", "Subtraction", each [Logout Date] - [Login Date], type duration),
AP_C2C | 7756416 | Comillo, [NAME] | 39670538 | [PHONE] | 2024-03-19 22:37:52.623000 | 2024-03-20 03:05:36.623000 | 04:27:44 |  | #"Renamed Columns" = Table.RenameColumns(#"Inserted Time Subtraction",{{"Subtraction", "Duration"}}),
AP_CANTONESE | 7756408 | Choo, Nana | 39670562 | [PHONE] | 2024-03-19 22:37:34.857000 | 2024-03-20 03:01:29.857000 | 04:23:55 |  | #"Split Column by Delimiter" = Table.SplitColumn(#"Renamed Columns", "Agent Name (ID)", [NAME].[NAME]({" ("}, [NAME].Csv, false), {"Agent Name (ID).1", "Agent Name (ID).2"}),
AP_CUSTOMER CARE | 7756417 | [NAME], Summer | 39670590 | [PHONE] | 2024-03-19 22:21:34.340000 | 2024-03-19 22:27:47.340000 | 00:06:13 |  | #"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Agent Name (ID).1", type text}, {"Agent Name (ID).2", type text}}),
AP_CUSTOMER CARE | 7756417 | [NAME], Summer | 39670590 | [PHONE] | 2024-03-19 22:34:25.497000 | 2024-03-20 01:56:50.497000 | 03:22:25 |  | #"Replaced Value" = Table.ReplaceValue(#"Changed [NAME].ReplaceText,{"Agent Name (ID).2"}),
AP_HOLIDAY CONCEPTS | 7756403 | Ching, Mariane | 39670577 | [PHONE] | 2024-03-19 22:40:55.010000 | 2024-03-20 02:24:40.010000 | 03:43:45 |  | #"Renamed Columns1" = Table.RenameColumns(#"Replaced Value",{{"Agent Name (ID).1", "Agent Name"}, {"Agent Name (ID).2", "Agent ID"}}),
AP_JAPAN_CWP | 7756413 | Kyung Im, [NAME] | 39670566 | [PHONE] | 2024-03-18 22:31:35.573000 | 2024-03-19 02:21:43.573000 | 03:50:08 |  | #"[NAME] by Delimiter1" = Table.SplitColumn(#"Renamed Columns1", "Team Name (ID)", [NAME].[NAME](" (", [NAME].Csv), {"Team Name (ID).1", "Team Name (ID).2"}),
AP_JAPAN_HGVC | 7756412 | [NAME], Ryeongna | 39670571 | [PHONE] | 2024-03-18 22:40:23.447000 | 2024-03-19 00:42:01.447000 | 02:01:38 |  | #"Changed Type3" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Team Name (ID).1", type text}, {"Team Name (ID).2", type text}}),
AP_JAPAN_HGVC | 7756412 | [NAME], Ryeongna | 39670571 | [PHONE] | 2024-03-19 00:44:30.110000 | 2024-03-19 01:51:15.110000 | 01:06:45 |  | #"Replaced Value1" = Table.ReplaceValue(#"Changed Type3",")","",Replacer.ReplaceText,{"Team Name (ID).2"}),
AP_JAPAN_HGVC | 7756412 | Okuna, Seri | 39578410 | [PHONE] | 2024-03-18 22:36:43.270000 | 2024-03-19 01:59:37.270000 | 03:22:54 |  | #"Renamed Columns2" = Table.RenameColumns(#"Replaced Value1",{{"Team Name (ID).1", "Team Name"}, {"Team Name (ID).2", "Team ID"}})
AP_KARMA ODYSSEY | 7756404 | Casaje, Faustin Louis | 39670545 | [PHONE] | 2024-03-18 22:38:28.157000 | 2024-03-19 02:28:19.157000 | 03:49:51 |  | in
AP_KARMA ODYSSEY | 7756404 | Domingo, [NAME] | 39670564 | [PHONE] | 2024-03-18 22:37:08.290000 | 2024-03-19 01:07:25.290000 | 02:30:17 |  | #"Renamed Columns2"
AP_KARMA ODYSSEY | 7756404 | Paras, Chrisha Clarise | 39670582 | [PHONE] | 2024-03-19 22:40:38.930000 | 2024-03-20 02:44:07.930000 | 04:03:29
AP_MANDARIN | 7756405 | Cheong, Wei Kong | 39670556 | [PHONE] | 2024-03-19 22:21:22.140000 | 2024-03-19 22:28:27.140000 | 00:07:05
AP_MANDARIN | 7756405 | Cheong, Wei Kong | 39670556 | [PHONE] | 2024-03-19 22:38:02.210000 | 2024-03-20 01:59:22.210000 | 03:21:20
AP_MANDARIN | 7756405 | [NAME], [NAME] | [NAME] (39670557 | [PHONE] | 2024-03-18 22:43:23.700000 | 2024-03-19 02:28:54.700000 | 03:45:31
AP_MANDARIN | 7756405 | [NAME], [NAME] | 39441314 | [PHONE] | 2024-03-19 22:25:17.550000 | 2024-03-20 03:53:50.550000 | 05:28:33
AP_MANDARIN | 7756405 | Ma, [NAME] | 39670543 | [PHONE] | 2024-03-18 22:42:19.180000 | 2024-03-19 01:02:23.180000 | 02:20:04
AP_MANDARIN | 7756405 | Wang, [NAME] | 39670572 | [PHONE] | 2024-03-18 22:24:07.943000 | 2024-03-19 02:16:53.943000 | 03:52:46
AP_MANDARIN | 7756405 | Wong, Amanda | 39670536 | [PHONE] | 2024-03-18 22:48:34.303000 | 2024-03-19 01:01:43.303000 | 02:13:09
AP_OB RENEWAL | 7756414 | [NAME], [NAME] | 39670579 | [PHONE] | 2024-03-18 22:39:13.217000 | 2024-03-19 01:02:27.217000 | 02:23:14
AP_OB RENEWAL | 7756414 | [NAME], [NAME] | 39670573 | [PHONE] | 2024-03-19 22:21:28.500000 | 2024-03-20 00:44:47.500000 | 02:23:19
AP_OB SPACEBANK | 7756415 | Marquez, [NAME] | 39670544 | [PHONE] | 2024-03-19 22:31:31.767000 | 2024-03-20 01:13:05.767000 | 02:41:34
AP_PACIFIC | 7756401 | [NAME], [NAME] | 39670546 | [PHONE] | 2024-03-19 22:39:10.693000 | 2024-03-20 02:47:38.693000 | 04:08:28
AP_PACIFIC | 7756401 | Domingo, Mirahnie | 39670552 | [PHONE] | 2024-03-19 22:39:26.770000 | 2024-03-20 01:11:03.770000 | 02:31:37
AP_PACIFIC | 7756401 | Ducut, [NAME] | 39670569 | [PHONE] | 2024-03-19 22:39:19.340000 | 2024-03-20 02:47:38.340000 | 04:08:19
AP_PACIFIC | 7756401 | Galang, [NAME] | 39670554 | [PHONE] | 2024-03-18 22:38:28.163000 | 2024-03-19 01:01:07.163000 | 02:22:39
AP_PACIFIC | 7756401 | [NAME], Yvon | 39441324 | [PHONE] | 2024-03-18 22:36:01.227000 | 2024-03-19 02:02:54.227000 | 03:26:53
AP_PACIFIC | 7756401 | Manalac, Nina | 39670561 | [PHONE] | 2024-03-18 22:23:54.170000 | 2024-03-19 01:05:08.170000 | 02:41:14
AP_PACIFIC | 7756401 | Ortiz, Sherwin | 39670578 | [PHONE] | 2024-03-18 22:26:36.280000 | 2024-03-19 01:50:03.280000 | 03:23:27
AP_PACIFIC | 7756401 | Roque, [NAME] | 39670570 | [PHONE] | 2024-03-19 22:39:16.980000 | 2024-03-20 01:12:45.980000 | 02:33:29
AP_PACIFIC | 7756401 | Rosataso, Armine | 39670548 | [PHONE] | 2024-03-19 22:36:58.223000 | 2024-03-20 01:12:33.223000 | 02:35:35
AP_PACIFIC | 7756401 | Tibar, Eleazar | 39441312 | [PHONE] | 2024-03-18 22:37:06.827000 | 2024-03-19 02:00:12.827000 | 03:23:06
AP_RPM | 7756419 | Baluyut, [NAME] | 39441317 | [PHONE] | 2024-03-18 21:59:25.780000 | 2024-03-19 01:59:10.780000 | 03:59:45
AP_RPM | 7756419 | [NAME], [NAME]. Theresa | 39617648 | [PHONE] | 2024-03-18 22:24:40.933000 | 2024-03-19 02:02:59.933000 | 03:38:19
AP_RPM | 7756419 | [NAME], [NAME]. Theresa | 39617648 | [PHONE] | 2024-03-19 22:05:44.570000 | 2024-03-20 02:13:05.570000 | 04:07:21
AP_RPM | 7756419 | Santos, Carlo | 39441311 | [PHONE] | 2024-03-18 22:07:45.257000 | 2024-03-19 01:00:35.257000 | 02:52:50
AP_RPM | 7756419 | Santos, Carlo | 39441311 | [PHONE] | 2024-03-19 05:39:06.217000 | 2024-03-19 05:42:55.217000 | 00:03:49
AP_RPM | 7756419 | Santos, Carlo | 39441311 | [PHONE] | 2024-03-19 21:14:14.257000 | 2024-03-20 02:04:36.257000 | 04:50:22
AP_THAILAND | 7756410 | Pandoidan, Suwapat | 39670584 | [PHONE] | 2024-03-19 22:47:23.320000 | 2024-03-20 00:30:04.320000 | 01:42:41
AP_THAILAND | 7756410 | Wimonporn, [NAME] | 39441316 | [PHONE] | 2024-03-18 22:24:18.427000 | 2024-03-19 01:01:37.427000 | 02:37:19
AP_THAILAND | 7756410 | Wimonporn, [NAME] | 39441316 | [PHONE] | 2024-03-19 01:57:24.873000 | 2024-03-19 01:57:53.873000 | 00:00:29
AP_TLs | 7756418 | [NAME], [NAME] | 39441310 | [PHONE] | 2024-03-19 22:44:05.853000 | 2024-03-19 22:49:23.853000 | 00:05:18
AP_TLs | 7756418 | [NAME], [NAME] | 39441310 | [PHONE] | 2024-03-19 22:51:45.217000 | 2024-03-19 22:53:00.217000 | 00:01:15
AP_TLs | 7756418 | [NAME], [NAME] | 39441310 | [PHONE] | 2024-03-19 22:54:08.347000 | 2024-03-19 22:55:30.347000 | 00:01:22
AP_TLs | 7756418 | [NAME], [NAME] | 39441310 | [PHONE] | 2024-03-19 23:20:28.293000 | 2024-03-20 00:15:51.293000 | 00:55:23
AP_TLs | 7756418 | Flores, [NAME] | 39578510 | [PHONE] | 2024-03-18 22:53:11.263000 | 2024-03-19 01:22:42.263000 | 02:29:31
AP_TLs | 7756418 | [NAME] | 39578511 | [PHONE] | 2024-03-18 22:24:09.923000 | 2024-03-19 01:50:30.923000 | 03:26:21
AP_TLs | 7756418 | [NAME] | 39578511 | [PHONE] | 2024-03-19 22:21:21.937000 | 2024-03-20 03:17:29.937000 | 04:56:08
AP_TLs | 7756418 | Nyamkandeka, Salvador | 39617660 | [PHONE] | 2024-03-19 22:39:13.227000 | 2024-03-20 01:19:06.227000 | 02:39:53
AP_TLs | 7756418 | [NAME], [NAME] | 39441320 | [PHONE] | 2024-03-19 21:51:46.313000 | 2024-03-19 21:56:24.313000 | 00:04:38
AP_TLs | 7756418 | Sabeniano, Julius | 39257216 | [PHONE] | 2024-03-19 10:16:42.200000 | 2024-03-20 09:48:24.200000 | 23:31:42
AP_ULTIQA | 7756402 | Bell, Chloe | 39670555 | [PHONE] | 2024-03-19 22:21:45.957000 | 2024-03-20 01:20:20.957000 | 02:58:35
AP_ULTIQA | 7756402 | Crooks, [NAME] | 39670535 | [PHONE] | 2024-03-18 23:04:56.257000 | 2024-03-19 01:06:23.257000 | 02:01:27
AP_ULTIQA | 7756402 | Evans, Tika | 39670586 | [PHONE] | 2024-03-19 01:54:38.710000 | 2024-03-19 02:08:34.710000 | 00:13:56
AP_ULTIQA | 7756402 | [NAME], [NAME] | 39670580 | [PHONE] | 2024-03-18 22:40:29.503000 | 2024-03-19 01:11:38.503000 | 02:31:09
AP_ULTIQA | 7756402 | Samara, Carolin | 39670539 | [PHONE] | 2024-03-19 22:44:56.253000 | 2024-03-20 01:57:51.253000 | 03:12:55
AP_VIETNAM | 7756409 | [NAME], [NAME] | 39441318 | [PHONE] | 2024-03-18 22:34:50.277000 | 2024-03-19 02:42:02.277000 | 04:07:12
AP_VIETNAM | 7756409 | Ngo, Myanh | 39670585 | [PHONE] | 2024-03-18 22:38:40.417000 | 2024-03-19 02:22:40.417000 | 03:44:00
AP_VIETNAM | 7756409 | [NAME], [NAME] | 39670583 | [PHONE] | 2024-03-19 22:36:42.037000 | 2024-03-20 01:11:55.037000 | 02:35:13
AP_VIETNAM | 7756409 | Trinh, [NAME] | 39670565 | [PHONE] | 2024-03-18 22:38:24.103000 | 2024-03-19 01:02:31.103000 | 02:24:07
NA-Bridge | 7754194 | Crouch, Bradly | 30404600 | [PHONE] | 2024-03-19 07:21:19.277000 | 2024-03-19 16:30:47.277000 | 09:09:28
NA-Bridge | 7754194 | [NAME], [NAME] | 30404595 | [PHONE] | 2024-03-19 15:26:07.887000 | 2024-03-20 00:37:38.887000 | 09:11:31
NA-Bridge | 7754194 | Roebuck, Charles | 30404593 | [PHONE] | 2024-03-19 07:02:17.717000 | 2024-03-19 15:30:19.717000 | 08:28:02
NA-Bridge | 7754194 | Slonaker-Hayes, [NAME] | 34635648 | [PHONE] | 2024-03-19 07:56:24.903000 | 2024-03-19 16:02:30.903000 | 08:06:06
NA-Bridge | 7754194 | Weaver, [NAME] | 30404598 | [PHONE] | 2024-03-19 07:29:20.330000 | 2024-03-19 07:30:09.330000 | 00:00:49
NA-Bridge | 7754194 | Weaver, [NAME] | 30404598 | [PHONE] | 2024-03-19 07:30:17.473000 | 2024-03-19 15:09:58.473000 | 07:39:41
NA-RPM | 7755856 | Pool, Tia | 30404752 | [PHONE] | 2024-03-19 11:56:08.130000 | 2024-03-19 11:56:24.130000 | 00:00:16
T&L-Admin | 7754562 | Bird, [NAME] | 38874096 | [PHONE] | 2024-03-19 08:23:51.290000 | 2024-03-19 08:24:40.290000 | 00:00:49
T&L-Admin | 7754562 | Dials, [NAME] | 30309615 | [PHONE] | 2024-03-19 13:11:37.753000 | 2024-03-19 15:11:52.753000 | 02:00:15
T&L-Admin | 7754562 | Kerr, [NAME] | 34636243 | [PHONE] | 2024-03-19 16:39:33.610000 | 2024-03-19 17:57:22.610000 | 01:17:49
T&L-Admin | 7754562 | Summers, [NAME] | 34481090 | [PHONE] | 2024-03-19 08:49:39.070000 | 2024-03-19 08:54:28.070000 | 00:04:49
T&L-Admin | 7754562 | Summers, [NAME] | 34481090 | [PHONE] | 2024-03-19 08:54:33.250000 | 2024-03-19 08:57:30.250000 | 00:02:57