AnsweredAssumed Answered

If Statement issue with Time Calculation

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


If Statement issue with Time Calculation



                     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?