The average peak usage time and day for customer's calls

This will be interesting to solve can you please attache sample sheet with data.
I think we use average function in array to get result..

Without data nobody can predict what will be formula.

Also mention your answer manually so that we can work towards that.

Regards,
Suhas

Here is the attached data.

Many Thanks.

PFA excel sheet make changes for peak day.....add one more column and keep day data in text format and use average if instead of hours(use text formula to get day..text(cell, "dddd")

your data was too more hence i reduced data and formula run on lesser data.

Regards,
Suhas

Thank you for the formula but it does not work when I apply it to 8915 rows of data - not sure - the result is 20 as peak hour but I can see that the peak hour is 12-13