Calculate avg time to complete task

[larryjfoster]

Col A - has date/time in 15 min increments throughout work day
Col D - has various work tasks

How can I avg the amount of time it takes to complete a task per day?

Thank you for any help and please let me know if I can provide further clarification.

Date/Time	DEPT	Class	Task
3/8/18 9:15 AM	X	α	Ω
3/8/189:30 AM	X	α	Ω

<colgroup><col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;"> <col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="139" style="width: 104pt; mso-width-source: userset; mso-width-alt: 5083;"> <tbody> </tbody>

 

[jorismoerings]

Hi,

take a look at the AVERAGEIFS function.
https://support.office.com/en-us/article/averageifs-function-48910c45-1fc0-4389-a028-f7c5c3001690