AnsweredAssumed Answered

If Statement issue with Time Calculation

Question asked by ShaikhAtta on Aug 27, 2013
Latest reply on Aug 27, 2013 by philmodjunk

Title

If Statement issue with Time Calculation

Post

     Hello, 

                     I am applying a formula in which if the time is less than or equal the value set in a field the status will show CHECKIN and if it is more than or equal to another field then it will show CHECKOUT

     Here is the formula 

     If ( Time < StandardTime::TimeCheckIn ; "Check In"; If ( Time > StandardTime::TimeCheckOut; "Check Out" ))

Value I am using in StandardTime::TimeCheckIn = 09:00:00 AM

Value I am using in StandardTime::TimeCheckOut = 05:00:00 PM

      

Is the above correct?

Outcomes