| Monitoring Tool.xlsm | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | Login | Start | End | 9/12/2021 | 9/13/2021 | 9/14/2021 | 9/15/2021 | 9/16/2021 | 9/17/2021 | 9/18/2021 | 9/15/21 1:05 | |||
| 2 | a | 9/15/2021 1:00 | 9/15/21 2:00 | W | W | W | W | OFF | OFF | W | a | |||
| 3 | b | 9/14/2021 23:00 | 9/15/21 2:00 | W | W | W | W | OFF | OFF | W | b | |||
| 4 | c | 9/15/2021 23:00 | 9/16/21 1:00 | W | W | W | W | OFF | OFF | W | g | |||
| 5 | d | 9/15/2021 19:00 | 9/15/21 21:00 | W | W | W | W | OFF | OFF | W | ||||
| 6 | e | 9/15/2021 8:00 | 9/15/21 10:00 | W | W | W | W | W | OFF | OFF | ||||
| 7 | f | 9/15/2021 11:00 | 9/15/21 13:00 | W | W | W | W | W | OFF | OFF | ||||
| 8 | g | 9/15/2021 1:00 | 9/15/21 3:00 | OFF | OFF | W | W | W | W | W | ||||
| 9 | h | 9/15/2021 23:00 | 9/16/21 1:00 | W | W | OFF | OFF | W | W | W | ||||
| 10 | i | 9/15/2021 23:00 | 9/16/21 1:00 | W | W | OFF | OFF | W | W | W | ||||
Sheet3 | ||||||||||||||
Hello all, I need the login in first column based on the date and time provided in L1 cell(L1 value should be in between b and c columns), please help me with the formula.
