I need some help please, I have a list of data with the headlines
NAME
JOB TYPE
VIN NUMBER
SCAN TIME START
VIN NUMBER
SCAN TIME FINNISH
TIME TAKEN
Basically it’s for guys who are working, they scan a job card then I’ve run some VBA so that it is time stamped, they do this at the beginning and the end of their job and it times how long the job has taken I have then run a formula that shows minutes taken.
I need to think of a formula that will pull a particular person, their job task and there average time taken between particular dates or for today for a report
There are 5 possible jobs so I need there to be a total time taken to complete x job for everyone and then the break down underneath of individual times
For instance it should be like:
quality control: 77 units average time 4:00
James: x units average time x:xx
****: x units average time x:xx
Harry: x units average time x:xx
Number plates: xx units average time x:xx
Tom: x units average time x:xx
Ian: x units average time x:xx
there are a few different jobs and each day a person may do a different job, but that is in the data that I am pulling from. How would you guys look to do this?
anyone have any ideas ??
NAME
JOB TYPE
VIN NUMBER
SCAN TIME START
VIN NUMBER
SCAN TIME FINNISH
TIME TAKEN
Basically it’s for guys who are working, they scan a job card then I’ve run some VBA so that it is time stamped, they do this at the beginning and the end of their job and it times how long the job has taken I have then run a formula that shows minutes taken.
I need to think of a formula that will pull a particular person, their job task and there average time taken between particular dates or for today for a report
There are 5 possible jobs so I need there to be a total time taken to complete x job for everyone and then the break down underneath of individual times
For instance it should be like:
quality control: 77 units average time 4:00
James: x units average time x:xx
****: x units average time x:xx
Harry: x units average time x:xx
Number plates: xx units average time x:xx
Tom: x units average time x:xx
Ian: x units average time x:xx
there are a few different jobs and each day a person may do a different job, but that is in the data that I am pulling from. How would you guys look to do this?
anyone have any ideas ??