Calculate value if value greater than 20:00:00 hours

[Antonio_Savage11]

Hi guys,

I need to know alls days that have hour registered in range 20:00:00 hours to 22:00:00 hours  or equal 

Example: If the value are in this range like 21:01:10 it's true 

I have this function but just for one value : 

=IF(C2>$Q$2;"True";"False")

In cell Q2 i have the 20:00:00 hour VALUE

In cell C2: i have the hours 

Collumns; 

How can i calculate in a range 20:00:00 hours to 22:00:00 hours or 8pm to 10 pm

Thanks for all help guys 

best regards

[#2 · Accepted solution]

@Antonio_Savage11 

=IF(AND(C2>=$Q$2,C2<=$Q$2+1/12),TRUE,FALSE)

Maybe with this formula. 

[#3]

@Antonio_Savage11 

For example:

=IF(OR(HOUR(C2)={20;21});"True";"False")

or even

OR(HOUR(C2)={20;21})

[#4]

Thank you sir, and if i want to add in function if the days is saturday count all hours to 22:00:00 ? but the other days keep counting 20:00:00 to 22:00:00 its possible?

[#5]

@Antonio_Savage11 

Does C2 contain the date and time? If so:

=IF(WEEKDAY(C2)=7,HOUR(C2)<22,OR(HOUR(C2)={20,21}))

If the date is in another cell, say in B2:

=IF(WEEKDAY(B2)=7,HOUR(C2)<22,OR(HOUR(C2)={20,21}))