Validating Multiple Logins in vb6

Validating Multiple Logins in vb6

How can do I code in vb6 to capture the exact login time of employees in
my system.
My system is daily time records. Each employee has login schedule like
8:00am - TimeinAM, 12:00PM - TimeOUtAM, 1:00PM - TimeINPM, 5:00pm timeoutpm
I want to get all the time of employees and compute their lates and
undertime based from their login time and login schedule.
I'm very much concern with employees that has multiple logins in every
session. How do i manage that to know if it is belong to
TimeinAM,TimeOutAM,TimeinPM,or timeoutPM.
The structure of my table is I have these extra BreakTime Fields in every
session. here's how it look:
EmpID | TimeInAm | BreakOutAM | BreakInAM | TimeOutAM | TimeInPM |
BreakOutPM | BreakInPM TimeOutPM | Late | Undertime | Date |
sql is my database.
ANy one could help me , I will be very glad. Im working this for a month
now.,