# Formula building help đ

#### Gareth246

##### New Member
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

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

#### Peter_SSs

##### MrExcel MVP, Moderator
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

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

Replies
0
Views
162
Replies
2
Views
424
Replies
4
Views
406
Replies
4
Views
278
Replies
4
Views
185

1,130,181
Messages
5,640,643
Members
417,159
Latest member
Mayozero

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browserâs toolbar.
2)Click on the icon in the browserâs toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browserâs toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browserâs toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browserâs toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back