looking for the syntax for the following time and day

[cmeredith1973]

Hi - I have a date and time col. I can pull out the day of the week, and the hour in 2 seperate cols. What I am looking for is the formula, that would be if, and or. e.g. if the hour is >=5pm or 17 in 24time, and is a friday, or is simply saturday or sunday, to put an x. I have gotten here,=IF(AND(AA2=1,AB2="After 5"),"x","") but can loop in the friday after 5 and saturday/sunday.

THe 1 is a true/false statement, that its sat/sun in excel.

Thank you

 

[Oaktree]

Try the HOUR function: HOUR(AB2) >= 17

 

[cmeredith1973]

Thank you Oaktree, I think I need another AND. I have a formula that will pull out the HOUR(B2>17,"after hours). but its not connecting that it could be friday after 5, and saturday or sunday

 

[Oaktree]

=IF(OR(AND(Day is Friday, Hour >= 17), Day is Saturday or Sunday),"X","")
=IF(OR(AND(WEEKDAY(Date,2)=5,HOUR(Time)>=17),WEEKDAY(Date,2)>5),"X","")
=IF(OR(AND(WEEKDAY(AA2,2)=5,HOUR(AB2)>=17),WEEKDAY(AA2,2)>5),"X","")

 

[cmeredith1973]

Thats why you are the MrExcel MVP, Oaktree. That was awesome, works perfectly.