Task Tracking w/ barcode scanner

[jacob04370]

I'm looking for help with an excel function/macro that could use a barcode scanner to first scan the ID badge and then next an "activity" barcode (ex, shipping, packing, etc..). When the ID is initially scanned I would like the current time to be automatically entered. Next, when the barcode is scanned later in the day to select a new activity, I would like it to again track the current time in the initial "action" row, as well as create a new row for the following action and a column for "time spent" in the first activity.

My solution would look somewhat similar to this thread:
http://www.mrexcel.com/forum/excel-questions/672492-scan-barcode-excel-date-time-stamp-out.html

Here is an example of what the sheet could look like. Note that D2 and C5 are the same, because when ID "A" was scanned into the second activity (Shipping) it signaled the ending of their first activity (Packing).

ID Action Time In Time Out Time Spent
A Packing 10:05:00 AM 10:55:00 AM 50:00
B Shipping 10:15:00 AM 11:30:00 AM 15:00
C Packing 10:15:00 AM 11:30:00 AM 15:00
A Shipping 10:55:00 AM 11:30:00 AM 35:00

Let me know if there is any confusion, my explanation is a little convoluted. Thanks!

 

[jacob04370]

bump

 

[jacob04370]

bump