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.