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 ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Mar 08, 2022

    Antonio_Savage11 

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

    Maybe with this formula. 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 08, 2022

Antonio_Savage11 

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

Maybe with this formula. 

  • Antonio_Savage11's avatar
    Antonio_Savage11
    Copper Contributor
    Mar 16, 2022
    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?

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Mar 16, 2022

      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}))

Resources