# Thread: calculate with number and time

1. ## calculate with number and time

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

2. Please attach a sample workbook.

Do you have MS365? There is no Excel 2008, so I think that's just the release number).

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•