I'm stuck on the best way to summarize date. I have 30+ Techs, they each have their own workbook set out as per, "User Workbook Example"
Each tech may do a different job each day.. they may do the same, however in there workbook the jobs are laid out as tabs at the bottom.
My Example here is for Brake fluid. The tech goes to the tab that describes the job they are doing, they then scan a bar code at the beginning of a job and they scan the same bar code at the end, both of these scans are time and date stamped, two scans equals a job complete.
I have then opened a new workbook and ran multiple power quieres. One for each job, i.e. break fluid as per my picture, "Power Query Example"
What I am trying to archive is a summary as set out in my photo, "Desired Result"
To do this I'm guessing a formula would have to automatically pull names from the query. my problem also is that I don't just want to see the average time they are on a job I want to see the average time based on their first clocking at for example at 6 am and their last clock say 5 pm divided by the amount of jobs they did that day. As They could be spending a lot of time not clocked on to a job which would falsely make their averages seem ok.
Does anyone have any ideas I'm going insane here !!