Forum Discussion

Wdstk61's avatar
Wdstk61
Copper Contributor
Apr 09, 2023
Solved

Logic Function

Can I use the logic function with time, if time > 11:59 then ...?  If so, how?
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Apr 09, 2023

    Wdstk61 

    If you mean the logical function IF() and the comparison operator > then this could be:

    =IF(A3>TIME(11,59,0),100,-100)

    A3 contains a time value. 

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 09, 2023

Wdstk61 

If you mean the logical function IF() and the comparison operator > then this could be:

=IF(A3>TIME(11,59,0),100,-100)

A3 contains a time value. 

Resources