time matching help

hello,i want to do a attendance time match with the employee overtime.i want to check whether the employee is attend the overtime.currently i already have the employee overtime database is ms.access and the attendance time with txt file.please guide how to start the time macthing.

thanks!:)

In what format is the time stored?

hack:
hi,please reply.Time stored is 24 hours DateTime format.