Bar code scanners w/ excel

[Oly Steel Man]

This is general question for anyone. We have a machine shop which we create jobs and send them out to the machines for processing and then they are returned. We want a way of tracking time spent on jobs and who did them. I have the ability to print out bar codes and we have a scanner. What I want to know is if anyone has been able to use this technology with excel on a simple basis. Basically this employee enters his/her pin number, scans the job number and information in excel records pin number, job number, and time stamp. Same thing when job is returned. This would keep a running database which using formulas we could calculate a time efficiency for each job. If anyone could provide any useful information that would be great. I've pretty much built the "work order" system from the ground up so integrating this would be very easy because everything is excel based now.

[Cutter]

Does this help?

http://www.ehow.com/how_5016936_read...des-excel.html

or

http://excel-expert.com/blog/2011/03...rs-with-excel/