Spreadsheet: 704243d1605460408-sumifs-between-dates-and-times-vendas-online-2020
Sheet: General Sales

Data de criação | [NAME] | Canal | Id Pedido | Nº pedido BigBuy | Total pedido | Desvio | [NAME] | Estado
2020-11-12 00:00:00 | 12:56:12 | Fnac | 0N3K8VXLWS40C | 12547528 | 63.43 | 2.54 | 7.78 | Em processo
2020-11-12 00:00:00 | 12:14:07 | Fnac | 0FQ628B3YB5G8 | 12547408 | 38.64 | 1.19 | 4.03 | Em processo
2020-11-11 00:00:00 | 21:22:38 | Fnac | 0V02FNXL0CV3Y | 12545090 | 124.79 | 1.39 | 17.66 | Enviado
2020-11-11 00:00:00 | 20:19:08 | Fnac | 1HN0V81VH3V2A | 12544927 | 40.68 | 0.54 | 6.41 | Enviado
2020-11-11 00:00:00 | 19:56:10 | Fnac | 0F70SVL69WUQA | 12544871 | 31.82 | 1.19 | 2.11 | Entregue
2020-11-11 00:00:00 | 19:32:42 | Fnac | 0FFGCVLLIDQ6G | 12544770 | 12.09 | -0.96 | -0.48 | Enviado
2020-11-11 00:00:00 | 16:32:32 | Fnac | 19QPBPKXSNN2Y | 12543912 | 26.12 | -0.39 | 3.12 | Enviado
2020-11-11 00:00:00 | 15:44:03 | Fnac | 1PGRIZ4P06LB6 | 12543648 | 483.24 | 8.41 | 79.79 | Enviado
2020-11-11 00:00:00 | 15:33:33 | Fnac | 0UGUEQIWBLALG | 12543583 | 128.88 | 0.04 | 18.86 | Entregue
2020-11-11 00:00:00 | 11:20:44 | Fnac | 1P0EVZN26GUZC | 12542676 | 29.68 | 0.54 | 4.21 | Enviado
2020-11-11 00:00:00 | 09:03:29 | Fnac | 08235DVV3HXGS | 12542151 | 26.91 | 1.19 | 2.21 | Em processo
2020-11-10 00:00:00 | 17:48:52 | Fnac | 0NHBB9LP942I0 | 12540791 | 71.64 | 0.04 | 9.13 | Entregue
2020-11-10 00:00:00 | 15:36:10 | Fnac | 1HKF1H1F41PD0 | 12539995 | 18.01 | -0.17 | 1.08 | Enviado
2020-11-10 00:00:00 | 11:21:11 | Fnac | 1H9JFR6U5P29A | 12539134 | 140.37 | 0.01 | 21.56 | Enviado
2020-11-09 00:00:00 | 18:58:01 | Fnac | 00ON7P9YA3YZ6 | 12536022 | 14.68 | 0.04 | 0.76 | Enviado
2020-11-09 00:00:00 | 18:47:47 | Fnac | 1OV2RRTYYWJHS | 12536033 | 33.61 | 1.19 | 3.46 | Entregue
2020-11-09 00:00:00 | 18:42:37 | Fnac | 1H9BM0RDCHTRU | 12535787 | 32.45 | 2.04 | 5.89 | Entregue
2020-11-09 00:00:00 | 15:34:15 | Fnac | 0UXG0YKYPKKKI | 12534865 | 71.64 | 0.04 | 9.98 | Entregue
2020-11-09 00:00:00 | 11:36:41 | Fnac | 0FF9DROU5E846 | 12533887 | 34.39 | 0.54 | 5.48 | Entregue
2020-11-09 00:00:00 | 10:43:46 | Fnac | 1OUXRHHBXH3PM | 12533498 | 12.67 | 0.04 | 1.56 | Enviado
2020-11-09 00:00:00 | 10:38:27 | Fnac | 0UX9ZZIGHWCM6 | 12533494 | 23.57 | 1.19 | 2.33 | Entregue
2020-11-08 00:00:00 | 22:27:40 | Fnac | 008GEK8Z7RRA8 | 12532097 | 10.47 | 0.04 | 0.63 | Entregue
2020-11-08 00:00:00 | 21:22:18 | Fnac | 0V2QZVIFQ77L6 | 12531987 | 72.33 | 0.04 | 9.75 | Entregue
2020-11-08 00:00:00 | 20:22:40 | Fnac | 1PGQIVWVUDQXI | 12531880 | 17.91 | 0.04 | 0.45 | Entregue
2020-11-08 00:00:00 | 20:07:05 | Fnac | 0N8Y1QNH6A3V8 | 12531858 | 24.51 | 0.19 | 2.85 | Entregue
2020-11-08 00:00:00 | 16:45:55 | Fnac | 0FVU3SZNUW3SC | 12531377 | 12.78 | 0.84 | 1.38 | Entregue
2020-11-08 00:00:00 | 09:57:09 | Fnac | 1A1M8GCYB3GQ0 | 12530566 | 40.15 | 0.76 | 5.27 | Entregue
2020-11-08 00:00:00 | 08:02:33 | Fnac | 1OXO386TRRA44 | 12530428 | 28.95 | 0.19 | 3.64 | Entregue
2020-11-08 00:00:00 | 05:43:56 | Fnac | 0MVDQ29MLYBRM | 12530368 | 10.82 | 0.84 | 1.48 | Entregue
2020-11-07 00:00:00 | 21:11:56 | Fnac | 1WZKHH497GNA4 | 12529411 | 24.9 | 0.04 | 0.53 | Entregue
2020-11-07 00:00:00 | 18:45:12 | Fnac | 1OXRBHRIJR0VK | 12529060 | 21.56 | 0.04 | 2.55 | Entregue
2020-11-06 00:00:00 | 22:19:12 | Fnac | 0MVDVMIUBF8O0 | 12526477 | 24.51 | 0.19 | 2.85 | Entregue
2020-11-06 00:00:00 | 21:25:30 | Fnac | 0F9TIA38OAIP6 | 12526400 | 53.05 | 0.77 | 8.52 | Enviado
2020-11-06 00:00:00 | 18:04:13 | Fnac | 122DHHQH9QPAA | 12525959 | 72.33 | 0.04 | 9.75 | Entregue
2020-11-06 00:00:00 | 17:59:52 | Fnac | 00LXXUL04B5IE | 12525955 | 25.41 | 0.04 | 0.91 | Entregue
2020-11-06 00:00:00 | 16:42:34 | Fnac | 0V05JB4MRYGWY | 12525804 | 114.88 | 0.04 | 20.35 | Entregue
2020-11-06 00:00:00 | 13:45:10 | Fnac | 1WM012UFATCYC | 12525880 | 233.81 | 1.24 | 34.79 | Entregue
2020-11-06 00:00:00 | 11:32:20 | Fnac | 0N0YSNWXYK3ZU | 12524657 | 22.42 | 0.04 | 1.4 | Enviado
2020-11-05 00:00:00 | 20:45:28 | Fnac | 07OGUNVIXZVUM | 12522410 | 48.25 | 2.54 | 5.77 | Entregue
2020-11-05 00:00:00 | 12:17:09 | Fnac | 0FQ78AFHNCX7M | 12520317 | 50.87 | 1.19 | 8 | Entregue
2020-11-05 00:00:00 | 11:12:38 | Fnac | 1WWX1MEOGQNH4 | 12520045 | 25.49 | 0.04 | 1.42 | Entregue
2020-11-05 00:00:00 | 09:55:06 | Fnac | 0FVQB09YM9QMA | 12519671 | 22.23 | 0.04 | 1.24 | Enviado
2020-11-04 00:00:00 | 10:00:12 | Fnac | 0FKX1758NZL6G | 12513459 | 24.1 | 0.04 | 1.58 | Entregue
2020-11-03 00:00:00 | 22:09:22 | Fnac | 1HC7UUZ09A590 | 12512628 | 24.1 | -0.79 | 1.58 | Entregue
2020-11-02 00:00:00 | 19:30:57 | Fnac | 1WJ8SM2L6QT9M | 12505357 | 25.67 | -0.79 | 0.74 | Entregue
2020-11-02 00:00:00 | 15:10:46 | Fnac | 1HHJZLNJ2ZPJ2 | 12504580 | 24.6 | -0.41 | 3.75 | Em processo
2020-11-02 00:00:00 | 14:22:41 | Fnac | 0FQDYS1N574MM | 12504398 | 45.23 | 0.42 | 7.38 | Entregue
2020-11-01 00:00:00 | 22:33:36 | Fnac | 07TQZSU2E9XFW | 12502785 | 26.31 | 0.36 | 2.41 | Entregue
2020-11-01 00:00:00 | 18:17:29 | Fnac | 0MY68P7A2QBI6 | 12502223 | 15.22 | -1.79 | -0.81 | Enviado
2020-11-01 00:00:00 | 14:06:34 | Fnac | 0N8Y302F7H8DU | 12501764 | 14.57 | -0.79 | 0.3 | Entregue
2020-11-01 00:00:00 | 12:20:49 | Fnac | 0FCN0YR0BH81W | 12501448 | 12.95 | -0.79 | -0.14 | Entregue
2020-10-31 00:00:00 | 21:13:22 | Fnac | 1OXS9SL5M8Z38 | 12500367 | 10.82 | 0.01 | 1.1 | Enviado
2020-10-31 00:00:00 | 16:14:39 | Fnac | 00B11OS7783S2 | 12499955 | 16.93 | -0.79 | 2.72 | Entregue
2020-10-30 00:00:00 | 20:56:02 | Fnac | 1P376YK1HOUOS | 12498875 | 24.9 | -0.79 | 1.02 | Entregue
2020-10-29 00:00:00 | 23:28:06 | Fnac | 07TUSV8FA6UYC | 12496776 | 31.12 | 1.21 | 4.91 | Entregue
2020-10-29 00:00:00 | 17:05:15 | Fnac | 00OUEOXRRBX0M | 12496232 | 14.57 | -0.79 | 0.71 | Entregue
2020-10-29 00:00:00 | 16:10:23 | Fnac | 1A7433EP798PY | 12496301 | 38.18 | 0.36 | 5.23 | Entregue
2020-10-29 00:00:00 | 15:11:15 | Fnac | 07OBVPPJDALRW | 12495988 | 26.5 | 0.81 | 2.31 | Entregue
2020-10-29 00:00:00 | 14:59:05 | Fnac | 1OUVWGZZ6BKNG | 12495970 | 44.33 | 0.69 | 5.72 | Entregue
2020-10-28 00:00:00 | 23:57:00 | Fnac | 002VPNKUJKMXK | 12494843 | 31.3 | 0.42 | 5.51 | Entregue
2020-10-28 00:00:00 | 13:09:38 | Fnac | 1HSMJ2IX5ZI8O | 12493882 | 25.56 | 0.01 | 2.04 | Entregue
2020-10-28 00:00:00 | 06:59:51 | Loja na mão | 34985 (34985) | 12492645 | 34.42 | 0.12 | 12.24 | Entregue
2020-10-27 00:00:00 | 18:56:34 | Fnac | 0FVVYHUVKIU44 | 12491566 | 14.57 | -0.79 | 0.71 | Entregue
2020-10-26 00:00:00 | 13:28:04 | Fnac | 07ZDWPP3RF2E2 | 12488075 | 547.51 | -0.71 | 60.85 | Entregue
2020-10-25 00:00:00 | 14:25:23 | Fnac | 0087NRJHSJGCY | 12486012 | 48.11 | 1.71 | 3.8 | Entregue
2020-10-24 00:00:00 | 10:55:28 | Fnac | 0F76XBMXOEY9C | 12484418 | 14.05 | -1.21 | 0.09 | Entregue
2020-10-23 00:00:00 | 14:29:12 | Fnac | 0UOZIYTK1VZQ2 | 12483981 | 33.65 | 0.36 | 3.06 | Entregue
2020-10-23 00:00:00 | 06:50:44 | Fnac | 0MY79MA0R1HTW |  | 24.35 |  |  | Manual sent
2020-10-22 00:00:00 | 22:53:06 | Fnac | 1HK962BB22DH4 | 12482197 | 46.34 | 0.42 | 8.26 | Entregue
2020-10-22 00:00:00 | 17:40:49 | Fnac | 1PE2Z57SIQXI8 | 12481708 | 31.43 | 0.51 | 2.97 | Enviado
2020-10-21 00:00:00 | 17:45:39 | Fnac | [NAME] | 12478875 | 14.9 | 0.36 | 2.5 | Entregue
2020-10-20 00:00:00 | 13:05:21 | Fnac | 1WU98ZOIO3IDU | 12477067 | 9.67 | -1.79 | -0.78 | Entregue
2020-10-13 00:00:00 | 16:11:23 | Loja na mão | 11548 (11548) | 12455031 | 27.74 | -1.7 | 9.62 | Cancelado
2020-11-11 00:00:00 | 17:11:23 | Direto |  |  | 2307.07 | 0 |  | [NAME]
2020-11-12 00:00:00 | 21:36:38 | Fnac | 1WRE7GNVFZS5Q | 12549121 | 16.97 | -0.17 | 0.45 | Enviado
2020-11-12 00:00:00 | 20:43:00 | Fnac | 12DAMWPMYHOCG | 12548992 | 63.43 | 2.54 | 8.7 | Em processo
2020-11-12 00:00:00 | 22:42:37 | Fnac | 0FHYQGHTY7QLS | 12549430 | 26.92 | 0.19 | 4 | Em processo
2020-11-12 00:00:00 | 22:39:49 | Fnac | 1PBGLDEZ873YW | 12549429 | 45.73 | 2.04 | 8.44 | Enviado
2020-11-14 00:00:00 | 14:38:36 | Fnac | 1P8O23GIK7QGO | 12553895 | 18.32 | 0.04 | 1.6 | Enviado
2020-11-14 00:00:00 | 13:04:55 | Fnac | 19YYUPUXD0AIS | 12553548 | 43.88 | 2.04 | 7.52 | Em processo
2020-11-14 00:00:00 | 12:48:54 | Fnac | 127YMQQXCN9K0 | 12553524 | 122.31 | 1.39 | 19.45 | Em processo
2020-11-14 00:00:00 | 12:25:24 | Fnac | 1HKE3HKKUXMHQ | 12553483 | 14.97 | 1.19 | 2.33 | Em processo
2020-11-14 00:00:00 | 11:35:52 | Fnac | 1WM23PTBMQHBE | 12553399 | 58.66 | 0.84 | 9.34 | Em processo
2020-11-13 00:00:00 | 23:21:25 | Fnac | 1P5RUK3Q6NMW0 | 12552763 | 51.95 | 3.09 | 10.87 | Em processo
2020-11-13 00:00:00 | 18:13:16 | Fnac | 1WZPKFICIS99S | 12552028 | 13.91 | 3.24 | -0.55 | Em processo
2020-11-13 00:00:00 | 16:38:56 | Fnac | 008CNET6XF6J0 |  | 71.64 |  |  | Pendente de revisão
2020-11-13 00:00:00 | 13:38:59 | Fnac | 12LMUD1QGF4DG | 12551143 | 13.92 | 0.04 | 1.4 | Enviado
2020-11-13 00:00:00 | 11:28:10 | Fnac | 07R4H1UXA0N94 | 12550761 | 26.06 | 0.89 | 3.34 | Em processo
2020-11-13 00:00:00 | 11:17:27 | Fnac | 1HHNNF0GZSHPS | 12550745 | 46.59 | 2.04 | 5.21 | Enviado
2020-11-13 00:00:00 | 08:50:10 | Fnac | [NAME] |  | 18.28 |  |  | Manually cancelled
2020-11-13 00:00:00 | 08:49:39 | Fnac | 1A4GLPSX2GIQK | 12550317 | 15.5 | 0.04 | 1.5 | Em processo
2020-11-13 00:00:00 | 08:44:07 | Fnac | 12ANX0B3BM7RA | 12550256 | 25.55 | 0.04 | 3.45 | Enviado
2020-11-12 00:00:00 | 22:42:37 | Fnac | 0FHYQGHTY7QLS | 12549430 | 26.92 | 0.19 | 4 | Em processo
2020-11-14 00:00:00 | 16:19:59 | Fnac | 19QPB5GXN0B00 | 12554269 | 24.9 | 0.04 | 1.02 | Em processo
2020-11-15 00:00:00 | 09:43:12 | Fnac | 127XGQLPQHN1C | 12555726 | 30.45 | 1.19 | 5.72 | Em processo
2020-11-14 00:00:00 | 23:57:03 | Fnac | 19TDUCI30NQ0Q | 12555271 | 46.32 | 0.98 | 5.56 | Em processo
2020-11-14 00:00:00 | 20:39:24 | Fnac | 1HPQCHPB7TKQ4 | 12554727 | 50.48 | 1.19 | 10.1 | Em processo
2020-11-14 00:00:00 | 18:56:56 | Fnac | 1HC3ZR7N2OJ8M | 12554537 | 27.27 | 0.76 | 4.66 | Em processo
2020-11-15 00:00:00 | 13:16:54 | Fnac | 1P0HKDQWG57J4 | 12556165 | 77.16 | 0.04 | 12.54 | Em processo
2020-11-15 00:00:00 | 13:26:36 | Fnac | 1HC6Z9PFCI532 | 12556182 | 26.22 | 0.49 | 1.04 | Em processo