Forum Discussion

Antonio_Savage11's avatar
Antonio_Savage11
Copper Contributor
Mar 08, 2022
Solved

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

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

 

4 Replies

Resources