Need help with Punch in and Punch out clock system please.

Good day all

I don't know if there is already a post like this, but I was wondering if anybody will be willing to assist me.

The company I work for uses a payroll program, but all the employees days, working hours, and overtime hours had to be input by means of manual job costing input. I have now recently changed it a bit, so I can do all the work in excel, and then just import it into the payroll program. This made the process go quicker, but I want to streamline it more.

I was wondering if it is possible for the employees to "clock in" by means of a bar-code, and the person's employee number, name and obviously date and time be posted to a sheet, and when they "clock out" it should record the "clock out" time in the next cell to the right of the "clock in" time. My aim is to record the times in and out, then calculate the difference in time per day, and then by means of vlookup to record the hours worked per person per day for the bi-weekly period to another sheet.

I have researched numerous videos, and posts, but cannot find a way to do this (that is how I came upon this forum.

Needless to say... i have hit a wall, and it feels like I have reached the limit of my knowledge.

The picture attached is a sample of how I would like to use the "clock in / out" page, by means of a form.

If anybody could assist me with this, it would be greatly appreciated.

Thank you in advance for any input.

Regards