Skip to main content
Topics#FormulasJames Ruggiero's Question
James Ruggiero (MJI) asked in #Formulas
Jun 13, 2022, 1:04 PM

Trying to create check box for "After Hours"

I am trying to create a check box that will auto check if the start time is between 4:30PM EST AND 8:00 EST or on saturday or sunday. The weekend part is working properly but for some reason I cannot get the time frame to work properly. I will post my formula below. Thank you!

OR(

TIMEVALUE("00:00:00.00")< TIMEVALUE(ActualStartTime) && TIMEVALUE(ActualStartTime) < TIMEVALUE("08:00:00.00"),

TIMEVALUE("23:59:59.00")> TIMEVALUE(ActualStartTime) && TIMEVALUE(ActualStartTime) > TIMEVALUE("16:30:00.00"),

WEEKDAY( DATEVALUE(ActualStartTime))= 1,

WEEKDAY( DATEVALUE(ActualStartTime))= 7

)
1 answer
  1. Arun Goel
    Apr 24, 2023, 6:12 AM
    Hi @James Ruggiero,

    Here's the solution for your question. Try using this formula:

    IF(

      OR(

        AND(

          NOT(ISBLANK(ActualStartTime)),

          TEXT(ActualStartTime) >= '16:30:00',

          TEXT(ActualStartTime) <= '20:00:00',

          TEXT(ActualStartTime) >= '00:00:00',

          TEXT(ActualStartTime) <= '04:00:00'

        ),

        TEXT(WEEKDAY(ActualStartTime)) = '1',

        TEXT(WEEKDAY(ActualStartTime)) = '7'

      ),

      true,

      false

    )

    Hope this helps.

    Thank you.

     
Write an answer...
0/9000