Hi,
Needing some help to be able to find the initial login and last logout for our staff.
I tried to use the following formula's but only returns with initial login and last logout across the dates.
{=MIN(IF(Sheet2!$A2:$A1000=Sheet1!$A$1,Sheet2!$C2:$C1000,MAX(Sheet2!$C2:$C1000)))}
{=MAX(IF(Sheet2!$A2:$A1000=Sheet1!$A$1,Sheet2!$C2:$C1000,MIN(Sheet2!$C2:$C1000)))}
So after applying the formula it returns to this
I am aiming to get similar to this one.
My source data is the following:
Hopefully can get some help. Thank you in advance.
Needing some help to be able to find the initial login and last logout for our staff.
I tried to use the following formula's but only returns with initial login and last logout across the dates.
{=MIN(IF(Sheet2!$A2:$A1000=Sheet1!$A$1,Sheet2!$C2:$C1000,MAX(Sheet2!$C2:$C1000)))}
{=MAX(IF(Sheet2!$A2:$A1000=Sheet1!$A$1,Sheet2!$C2:$C1000,MIN(Sheet2!$C2:$C1000)))}
So after applying the formula it returns to this
Staff A | ||
Login | Logout | |
1/02/2024 | 31/01/2024 15:04 | 9/02/2024 10:23 |
2/02/2024 | 31/01/2024 15:04 | 9/02/2024 10:23 |
3/02/2024 | 31/01/2024 15:04 | 9/02/2024 10:23 |
4/02/2024 | 31/01/2024 15:04 | 9/02/2024 10:23 |
5/02/2024 | 31/01/2024 15:04 | 9/02/2024 10:23 |
I am aiming to get similar to this one.
Staff A | ||
Date | Login | Logout |
1/02/2024 | 1/02/2024 5:59 | 1/02/2024 15:02 |
2/02/2024 | 2/02/2024 5:56 | 2/02/2024 15:04 |
3/02/2024 | ||
4/02/2024 | ||
5/02/2024 | 5/02/2024 6:04 | 5/02/2024 15:01 |
My source data is the following:
Staff Name | Log In | Log Out |
Staff A | 31/01/2024 15:04 | |
Staff A | 1/02/2024 5:59 | 1/02/2024 13:38 |
Staff A | 1/02/2024 13:39 | 1/02/2024 15:02 |
Staff A | 2/02/2024 5:56 | 2/02/2024 7:10 |
Staff A | 2/02/2024 7:10 | 2/02/2024 8:16 |
Staff A | 2/02/2024 8:18 | 2/02/2024 12:23 |
Staff A | 2/02/2024 12:23 | 2/02/2024 14:21 |
Staff A | 2/02/2024 14:37 | 2/02/2024 15:04 |
Staff A | 5/02/2024 6:04 | 5/02/2024 10:48 |
Staff A | 5/02/2024 10:49 | 5/02/2024 15:01 |
Hopefully can get some help. Thank you in advance.