Formula building help ?

[Gareth246]

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 ??

 

[Peter_SSs]

Welcome to the MrExcel board!

anyone have any ideas

I don't know if it something that I might be able to help with or not. However, whoever might try to help will have a better chance if they can see the actual layout and have some sample data (nothing sensitive of course) to test with and the expected results entered manually. The best way to do that is with XL2BB. Usually 10-20 rows would be enough so long as any variety in your data is included.

 

[jasonb75]

Looking at the question, AVERAGEIFS comes to mind, but without the XL2BB example that Peter has suggested, that is nothing more than a guess.