Formula building help 😁

Gareth246

New Member
Joined
Aug 20, 2020
Messages
7
Office Version
  1. 2019
Platform
  1. Windows
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 😂😬
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Dec 30, 2008
Messages
12,479
Office Version
  1. 365
Platform
  1. Windows
Looking at the question, AVERAGEIFS comes to mind, but without the XL2BB example that Peter has suggested, that is nothing more than a guess.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,746
Messages
5,626,625
Members
416,195
Latest member
tonmcg

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top