Applying 2 conditions to create the column

[Saravanan_ameer]

Hi All,

I have the data of the employees login, log out timing details, gender details.

I want to create the column as per the below conditions

If Emp Gender Is M and Log out time is before 3.30 pm then mark it as Early 

If Emp Gender Is F and Log out time is before 3.20 pm then mark it as Early 

OR ELSE Normal

i am able to apply any one if condition not able to apply 2 conditions.

[shreyamukkawar · Accepted solution]

Hi @Saravanan_ameer ,

Please find the below solution.

Flag = IF(Sheet1[log out]<3.30 && Sheet1[Gender]="M","Early",IF(Sheet1[log out]<3.20 && Sheet1[Gender]="F","Early","Normal"))

Best Regards,

Shreya Mukkawar

If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly.

[shreyamukkawar · Accepted solution]

Hi @Saravanan_ameer ,

Please find the below solution.

Flag = IF(Sheet1[log out]<3.30 && Sheet1[Gender]="M","Early",IF(Sheet1[log out]<3.20 && Sheet1[Gender]="F","Early","Normal"))

Best Regards,

Shreya Mukkawar

If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly.

[Saravanan_ameer]

Thanks for reply i need one more column that late by hh:mm which is for the Female how many hours they logout before 3.20 and also for Male before 3:30 how many hours

ex: The female is logout by 3 pm so she departure early by 0:20 and if the male is logged out by 3 pm so the value should reflect as 0:30 (I need it both in single column)

plesase help

[shreyamukkawar · Accepted solution]

Hi @Saravanan_ameer ,

1. Create a column time.

time = IF(Sheet1[Gender]="M",3.30-Sheet1[log out],IF(Sheet1[Gender]="F",3.20-Sheet1[log out])

2. Create a column flag 2

Flag 2 = IF(Sheet1[Flag]="Early",Sheet1[time])

Best Regards,

Shreya Mukkawar

If this post helps, then please consider Accept it as the solution to help the other members  find it more quickly and Like the solution.