calculate with number and time

krishak77

New member
Joined
Jun 21, 2021
Messages
6
Reaction score
0
Points
0
Excel Version(s)
2008
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.

NumberTimeStatus
14.30pmPast
15.30pmPast
16.30pmPresent
05.30pmPresent
05.40pmFuture

Thank you in advance.

Regards,
Anantha
 
Please attach a sample workbook.

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