convert non data base to data base format using formula

Dear Members,

we are using attendance sheet of employees in non-data base formate and would like to convert it in to data base format using formula.

in the attached example, the sheet with "attendance" show the employees present date in the month of january.

i would like to convert to data base format as per the sheet "time sheet". pls note the time in and time out are randomly entered and we need to ensure that there is no over time.

i want formulas to create this "time sheet" columns linked to attandance sheet.

pls guide me.