Forum Discussion
Applying 2 conditions to create the column
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.
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 2Flag 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.
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
Hi Saravanan_ameer ,
1. Create a column 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.