I have a timesheet in access with the following fields.
starttime
timeout1
tinein1
timeout1
timein2
finishtime
Everything is working great. Except for it is possible for them to enter the wrong time. For instance,
07:00am - starttime
11:00pm - timeout1 should be 11:00am
12:00pm = time in 1
5:00pm - finish time
they input wrong time and put pm instead of am making it 21 hours instead of 9 hours total for the day. is there a way to code or setup so that the user doesn't enter wrong time?
Any help greatly appreciated.