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.
[TABLE="width: 298"]
<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>[TR]
[TD="class: xl63, width: 113"]Date/Time[/TD]
[TD="class: xl63, width: 71"]DEPT[/TD]
[TD="class: xl63, width: 75"]Class[/TD]
[TD="class: xl63, width: 139"]Task[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]3/8/18 9:15 AM[/TD]
[TD="align: center"]X[/TD]
[TD]α[/TD]
[TD]Ω[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]3/8/189:30 AM[/TD]
[TD="bgcolor: transparent, align: center"]X[/TD]
[TD="bgcolor: transparent"]α[/TD]
[TD="bgcolor: transparent"]Ω[/TD]
[/TR]
</tbody>[/TABLE]

 

[jorismoerings]

Hi,

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