# Averaging time over multiple cells and YTD

#### jaybird2569

##### New Member
I have a spreadsheet to track employee efficiency over 16 different tasks. I am currently using formulas to determine their overall efficiency for the month by multiplying their time spent on each task (variable) by the amount of time it takes to do each task (constant). One of the issues is I can't add straight across the column because I have the number of tasks, constant and actual time. I then add all of the actual times across the column and divide by the number of hours worked for that month.
The formulas are ridiculous and get even more complicated as the months go on because I'm also trying to keep YTD totals but I can't just average all of the averages. I'm looking for an easier way to calculate this either VBA to run through the sheet and adding the columns for each person or keep using formulas that I have to create every month that's starting to take several hours to write. I currently have a formula that is adding 16 "totals" for each month divided by the total hours worked to get the YTD efficiency. For November that will be 176 totals (16x11) divided by 11 total hour cells. There has to be a better way. Maybe I need to set up the spreadsheet differently. Oh, by the way, I am a noob. I will post a screenshot later today.

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Replies
4
Views
144
Replies
3
Views
246
Replies
1
Views
524
Replies
1
Views
207
Replies
3
Views
224

1,203,236
Messages
6,054,303
Members
444,715
Latest member
GlitchHawk

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