Hi!
Background: I work with customer service and want to register how long they have to wait before they get their products. I receive a receipt from each customer and then we are multiple people at once picking their orders.
How I have done thus far:
I use the "Forms" function to add information like the table below.
The ordernumber is a scanned barcode and contains a "Enter" press.
The timestamp is a function that looks like this:
<tbody>
</tbody>
The data I extract is 1. Waitingtime depending on how many products and 2. Waitingtime depending on time of day.
The problems is that we don't do one customer at a time, so the ordernumber doesn't end up in a good order (like above.) This requires more post process then I would like.
To the question:
Is it possible for excel to recognize that the barcode has been scanned before and then add information in a new cell horizontally beside the first? I only want to enter "Number of products" and hit "Tab" once of twice.
<tbody>
</tbody>
Or is there a better solution to my problem? It has to be quick and don't require clicking around with a mouse.
Best Regards
PartyAlly
Background: I work with customer service and want to register how long they have to wait before they get their products. I receive a receipt from each customer and then we are multiple people at once picking their orders.
How I have done thus far:
I use the "Forms" function to add information like the table below.
The ordernumber is a scanned barcode and contains a "Enter" press.
The timestamp is a function that looks like this:
Code:
=IF(B2<>"",IF(C2<>"",C2,NOW()),"")
Number of products | Ordernumber | Timestamp |
2 | 1100 | 10:12:21 |
4 | 1200 | 10:14:08 |
2 | 1100 | 10:14:11 |
4 | 1200 | 10:14:20 |
<tbody>
</tbody>
The data I extract is 1. Waitingtime depending on how many products and 2. Waitingtime depending on time of day.
The problems is that we don't do one customer at a time, so the ordernumber doesn't end up in a good order (like above.) This requires more post process then I would like.
To the question:
Is it possible for excel to recognize that the barcode has been scanned before and then add information in a new cell horizontally beside the first? I only want to enter "Number of products" and hit "Tab" once of twice.
Number of products | Ordernumber | Ordernumber 2nd scan | Time in | Time out |
2 | 1300 | 1300 | 10:04:48 | 10:26:38 |
<tbody>
</tbody>
Or is there a better solution to my problem? It has to be quick and don't require clicking around with a mouse.
Best Regards
PartyAlly