Mar 08 2022 11:35 AM
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
Mar 08 2022 11:46 AM
SolutionMar 08 2022 11:46 AM
For example:
=IF(OR(HOUR(C2)={20;21});"True";"False")
or even
OR(HOUR(C2)={20;21})
Mar 16 2022 02:56 AM
Mar 16 2022 04:04 AM
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}))
Mar 08 2022 11:46 AM
Solution=IF(AND(C2>=$Q$2,C2<=$Q$2+1/12),TRUE,FALSE)
Maybe with this formula.