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 ...
- Mar 08, 2022
OliverScheurich
Mar 08, 2022Gold Contributor
- Antonio_Savage11Mar 16, 2022Copper 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?
- HansVogelaarMar 16, 2022MVP
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}))