Spreadsheet: 770218d1645896389-formula-returning-value-when-there-should-be-none-book1
Sheet: Sheet1

01:00:00 | True |  |  | 2022-02-01 00:00:00
Name | SAP Login | Shift | Department | First Scan | [NAME] | Last Scan | End Gap
Acosta, [NAME] | AcostaJ | 2 | inbound
Alramahi, [NAME] | AlramahiA | 1 | Outbound
[NAME], [NAME] | ANDERSONR | 2 | Outbound
[NAME], [NAME] | ANDERSOND | 2 | Outbound
[NAME], Jamarcus | AndersonJ | 3 | Outbound
[NAME], [NAME] | AVILAI | 1 | Outbound
[NAME], [NAME] | BARNETTJO | 2 | Outbound
Broadway, [NAME] | BroadwayC | 1 | Inbound
[NAME], [NAME] | BROWNJ | 3 | Outbound
[NAME], [NAME] | BrownJE | 3 | inbound
Campbell, [NAME] | CAMPBELLK | 3 | Inbound
Carruthers, Cedric | CarruthersC | 1 | Inbound
CLARK, [NAME] | ClarkM | 1 | Inbound
[NAME], Adrian | CollinsA | 3 | Inbound
Coronado, [NAME] | CORONADOJ | 2 | Inbound
[NAME], [NAME] | DAVISM | 3 | Outbound
[NAME], Abram | DiazAb | 3 | Outbound
[NAME], Stephen | DuncanS | 3 | Outbound
Eaves, Justin | EavesJ | 3 | Outbound
[NAME], [NAME] | FACUNDOD | 2 | Outbound
Figaro, Loragecar | FigaroL | 3 | Outbound
FLOWERS, PRECIOUS | FLOWERSP | 2 | Inbound
Gammill, [NAME] | GammillB | 3 | Outbound
[NAME], [NAME] | [NAME] | 2 | Inbound
Green, [NAME] | GREENA | 2 | Outbound
Guerra, Enrique | HoustonE | 3 | inbound
Guerra, Enrique | HoustonE | 3 | inbound
[NAME], [NAME] | [NAME] | 1 | Inbound
Hawkins, Quintis | HAWKINSQ | 2 | Inbound
HERNANDEZ, LAURENCIO | HERNANDEZL | 1 | Inbound
Hernandez, [NAME] | HERNANDEZJ | 3 | Inbound
Hernandez, Cesar | HernandezC | 3 | Outbound
[NAME], Jorge | HernandezJor | 2 | Inbound
HOUSTON, REXANN | HOUSTONR | 3 | Inbound
[NAME], [NAME] | HUNTJ | 2 | Outbound
[NAME], Dwaylon | JacksonDw | 3 | Inbound
[NAME], [NAME] | JacksonDa | 3 | Inbound
[NAME], Garry | JEFFERSONG | 1 | Outbound
[NAME], [NAME] | JohnsonC | 3 | Outbound
[NAME], COURTNEY | JohnsonCo | 3 | outbound
Jointer, Caltonette | JointerC | 3 | Outbound
Jones, [NAME] | JonesJ | 3 | Inbound
[NAME], Art | JOSEPHA | 1 | Outbound
KAMARA, [NAME] | [NAME] | 1 | Outbound
King, [NAME] | KingZ | 1 | Inbound
Martinez, [NAME] | MartinezC | 3 | outbound
MARTINEZ, [NAME] | Martinezjo | 2 | Outbound
MARTINEZ, [NAME] | MartinezJ | 2 | Outbound
Martinez, [NAME] | MartinezR | 2 | Inbound
McCoy, [NAME] | MccoyD | 3 | Outbound
Minor, Shauntel | MinorS | 2 | Outbound
MOORE, RAYSHAWN | MOORER | 1 | Outbound
Morales, [NAME] | MORALEST | 1 | [NAME]
Morin, Martin | MorinM | 3 | Outbound
nunnenkamp, [NAME] | NUNNENKAMPJ | 1 | Inbound
[NAME], [NAME] | OliverE | 1 | Outbound
Onken, Stacy | ONKENS | 2 | Outbound
Orellana, [NAME] | OrellanaD | 1 | Outbound
Pena, [NAME] | PenaM | 1 | Inbound
Pina, Amando | PINAAM | 1 | Outbound
powers, [NAME] | PowersN | 2 | Outbound
[NAME], [NAME] | PuckettT | 3 | Outbound
[NAME], [NAME] | RamirezB | 3 | Outbound
Rhodes, [NAME] | RHODESJ | 2 | Outbound
[NAME], [NAME] | RichardsonR | 3 | Inbound
Rivera, [NAME] | RiveraCh | 2 | Outbound
[NAME], [NAME] | ROBBINSW | 1 | Outbound
[NAME], [NAME] | ROBINSONDA | 2 | Inbound
Scott, [NAME] | ScottR | 3 | Inbound
Spates, [NAME] | SpatesP | 1 | Outbound
Specks, [NAME] | SPECKSB | 3 | Outbound
Spivey, [NAME] | SpiveyR | 2 | Inbound
[NAME], [NAME] | TaylorC | 3 | Inbound
[NAME], [NAME] | TaylorO | 2 | Inbound
[NAME], [NAME] | TaylorJ | 1 | Outbound
[NAME], [NAME] | THOMASE | 2 | Inbound
Torres, [NAME] | TorresR | 2 | Inbound
[NAME], [NAME] | VANZANDTC | 1 | Outbound
Vega, Cruz | VegaC | 1 | Inbound
Villareal, Jesse | VILLARREALJE | 2 | outbound
[NAME], [NAME] | WILLIAMSC | 1 | Inbound
[NAME], [NAME] | WILLIAMSR | 3 | Inbound
[NAME], [NAME] | WilliamsJa | 1 | Outbound