IF condition of Time and Day

[emina002]

Hi to all. I go simple problem regarding of IF condition with time and day involved with it. The logic is, I have to column Start time and Day. If Start time column is beyond 6PM of Day Friday to 6AM Day Monday it will display a value of "Personal".

Now if the Day is Monday with Start time of 6AM beyond to Friday 5:59PM for example it will display the value of "Business"

here is my sample formula

Please Login or Register  to view this content.

my problem is when the Day is "Monday" and has a Start time of 5:59AM it should return "Personal.but it always return "Business".

Kindly give me some help with my formula.Thanks a lot!

[Bob Phillips]

Try

=IF(OR(F75="Saturday",F75="Sunday",AND(F75="Friday",D75>=--"18:00:00"),AND(F75="Monday",D75<--"06:00:00")),"P","B")

[martindwilson]

the "and" part
D75>TIME(18,0,0),D75<TIME(6,0,0)
cannot be met

[emina002]

thanks a lot Bob Phillips and martindwilson for your help.My problem has been solve.:D