Forum Discussion

AI14's avatar
AI14
Helper III
3 years ago

if statement time based

Hi   Is there a formula to compare 2 times if less than or more than a fixed time for example,   Actual 09:59 Target 10:00   if Actual is less than Target by 10 mins then 1 if not 0    
BrianConnelly's avatar
BrianConnelly
Resolver III
3 years ago

For this we will convert your time to DateTime using the TimeValue and then calculate minutes using DateDiff.

DATEDIFF (TIMEVALUE(time_text) ,TIMEVALUE(time_text) ,MINUTE)

 

Then build your switch statement or if statement for the logic.  Many ways to do this, but here are a few...

SWITCH(TRUE()
,DATEDIFF (TIMEVALUE(time_text) ,TIMEVALUE(time_text) ,MINUTE) > 10, 1
,0)

 

IF(DATEDIFF (TIMEVALUE(time_text) ,TIMEVALUE(time_text) ,MINUTE)>10,1,0)