Programado: Load*Inline [Data,Caixa,Operador,HoraInitProg,HoraFimProg,HoraInitReal,HoraFimReal 11/10/2021, A01, Ana, 06:00:00, 11:00:00, 05:57:00, 09:57:00, 11/10/2021, A01, Bela, 11:05:00, 15:05:00, 11:12:00, 15:10:00, 11/10/2021, A01, Felicia, 16:00:00, 20:00:00, 15:55:00, 19:55:00, 11/10/2021, A01, Gabriela, 20:30:00, 12/10/2021 00:30:00, 20:40:00, 12/10/2021 00:39:00, 11/10/2021, A02, Esther, 05:30:00, 09:30:00, 05:38:00, 09:39:00, 11/10/2021, A02, Carla, 10:00:00, 14:00:00, 09:56:00, 13:59:00, 11/10/2021, A02, Duda, 15:00:00, 19:00:00, 14:53:00, 18:54:00, 11/10/2021, A02, Helen, 20:00:00, 12/10/2021 00:00:00, 20:07:00, 12/10/2021 00:10:00, 12/10/2021, A01, Ilda, 06:00:00, 11:00:00, 06:10, 10:13:00, 12/10/2021, A01, Carla, 11:05:00, 15:05:00, 11:03:00, 15:04:00, 12/10/2021, A01, Felicia, 16:00:00, 20:00:00, 15:50:00, 19:51:00, 12/10/2021, A01, Gabriela, 20:30:00, 12/10/2021 00:30:00, 20:23:00, 12/10/2021 00:26:00, 12/10/2021, A02, Bela, 05:30:00, 09:30:00, 05:30:00, 09:30:00, 12/10/2021, A02, Ana, 10:00:00, 14:00:00, 09:57:00, 14:01:00, 12/10/2021, A02, Duda, 15:00:00, 19:00:00, 14:57:00, 18:57:00, 12/10/2021, A02, Helen, 20:00:00, 12/10/2021 00:00:00, 19:56:00, 23:54:00, ]; //--------------------------------------------------------------------------------------- Operações: Load*Inline [Data, Hora, Caixa, Faturado, 11/10/2021, 06:13:00, A01, -1175,08, 11/10/2021, 07:53:00, A01, 1732,23, 11/10/2021, 09:33:00, A01, -141,82, 11/10/2021, 11:03:00, A01, -1205,47, 11/10/2021, 13:43:00, A01, 1053,52, 11/10/2021, 16:03:00, A01, 1944,96, 11/10/2021, 17:13:00, A01, -1063,65, 11/10/2021, 18:03:00, A01, 729,36, 11/10/2021, 20:53:00, A01, -1266,25, 11/10/2021, 23:23:00, A01, -587,54, 11/10/2021, 06:35:00, A02, 232,99, 11/10/2021, 09:55:00, A02, 1955,09, 11/10/2021, 12:15:00, A02, 1418,2, 11/10/2021, 15:15:00, A02, 1286,51, 11/10/2021, 16:55:00, A02, 50,65, 11/10/2021, 18:35:00, A02, 1955,09, 12/10/2021, 06:48:00, A01, -131,69, 12/10/2021, 09:58:00, A01, 2005,74, 12/10/2021, 12:28:00, A01, 1245,99, 12/10/2021, 13:28:00, A01, 881,31, 12/10/2021, 15:18:00, A01, -1499,24, 12/10/2021, 17:58:00, A01, -931,96, 12/10/2021, 20:28:00, A01, -1397,94, 12/10/2021, 06:05:00, A02, -40,52, 12/10/2021, 08:35:00, A02, 263,38, 12/10/2021, 08:55:00, A02, 1053,52, 12/10/2021, 11:05:00, A02, -1094,04, 12/10/2021, 14:25:00, A02, 1134,56, 12/10/2021, 14:35:00, A02, -840,79, 12/10/2021, 15:55:00, A02, -1428,33, 12/10/2021, 18:25:00, A02, 1458,72, 12/10/2021, 20:45:00, A02, -1175,08, ] ; //--------------------------------------------------------------------------- Inner Join IntervalMatch ( Hora, Data ,Caixa ) LOAD HoraInitReal,HoraFimReal, Data, Caixa Resident Programado; // A partir daqui, montar na Pasta uma tabela com //Data , Caixa , Hora , Operador , Faturado , Acumulado por operador