Average of Times Spanning Midnight

Originally Posted by LJenny

I would just like for Row 27 and Column AB to correctly display the average time for the team or day, such as "9:00 PM".

The reason I asked you to manually calculate and enter in the workbook the average you expect to see for a few example rows is that experience tells us that this whole process of answering requests is much helped if we know the end goal. It save a lot of to-ing and fro-ing and misuderstanding. We can test our ideas knowing what the result should be.

And incidentally there's no need to requote previous comments unless absolutely necessary for clarification.