Forum Discussion
Antonio_Savage11
Mar 08, 2022Copper Contributor
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
Sort By
- OliverScheurichGold Contributor
- Antonio_Savage11Copper ContributorThank 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?
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}))