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?