Hello, I'm creating an application for timekeeping. It has two tables, an employee table and another record table. The employee table has the entry time of each employee. I would like to restrict registration to 15 minutes before check-in time and 15 minutes after check-in time. For example: if entry is at 07:00, the employee could only register from 06:45 until 07:15. Can anyone help me, thank you in advance.
Solved! Go to Solution.
Try VALID IF =
AND(
TimeNow()>=[CheckInTime]-"000:15:00",
TimeNow()<=[CheckInTime]+"000:15:00"
)
Try VALID IF =
AND(
TimeNow()>=[CheckInTime]-"000:15:00",
TimeNow()<=[CheckInTime]+"000:15:00"
)
Thank you very much, it worked.
User | Count |
---|---|
18 | |
10 | |
8 | |
5 | |
5 |