Barcode vs Excel

It's possible, but that could take a lot of time to produce. Additional information would also be needed - Such as the "calculation" for finding out what the job cost.

Cost for the labor - how much does he/she make/hr?

Are you calculating parts in this equation?

How would you specify the estimated time to complete the work?

Also, to make this database fool-proof, you would need to lock the excel sheet from editing, create a userform where the data entry & barcode scanning will take place, write additional code to perform the many tasks you desire.

Now, you could put a formula in a cell to check when someone scanned a barcode. Make the formula timestamp when it was scanned, then have another cell do the same for the end of the process.

The only problem with that is USER-ERROR and/or SABOTAGE.

1. Scanning the barcode twice as different jobs
2. Scanning into the wrong cell on the sheet
3. "Accidentally" overwriting the formula
4. "Intentionally" editing the timestamp to make themselves look better

Setting up just cells on a sheet leaves the database vulnerable.

Provide more information, and maybe I could write a small program, like a macro, to do this.