Lextree Simply the best software for managing legal entities and documents.
The Berkman Letter Practical analysis and commentary for business, law, and more.

checking time value against an access table

my company has defined work hours (0730-1600) M-F, for our folks who travel, they can earn some OT when they fly. It must be after the end of the workday. So as an example, Employee A departs on Monday at noon to go to the airport and his/her flight departs at 16:50. Employee A is entitled to 1 hour of OT (round the 50 minutes). 
I have an MS Access table that stores has two columns and they are StartWD (0730) and EndWD (1600).  
i have an MS Access form for the employee to compute the overtime, my issue is how do I compare the date/time on the form against the table? 

I have no idea how to make this happen