Hello All,


I need formula for the below criteria

If on the A column having greater than 0 and on B column lesser than 5.30pm, then on C column it should map as Past
If on the A column having Equals to 1 and on B column Greater than 5.30pm, then on C column it should map as Present
If on the A column having Equals to 0 and on B column lesser than 5.30pm, then on C column it should map as Present
If on the A column having Equals to 0 and on B column Greater than 5.30pm, then on C column it should map as Future.

Below are the few examples which i need like below.

Number Time Status
1 4.30pm Past
1 5.30pm Past
1 6.30pm Present
0 5.30pm Present
0 5.40pm Future

Thank you in advance.

Regards,
Anantha