Create Pivot Table with group dates; summarize values by average; h:mm

I'm way over my head when it comes to creating pivot tables in vba.

Attached data. Each week through the month this report is run and all the worksheets (31) are combined to a sheet named Combined.
I need this worksheet to create a pivot table onto a sheet named Pivot
Dates need to be grouped by month
Both Aux columns are sum by average and formatted by h:mm

The attached has a sample graphic of what the final should look like. (We copy\paste this data into another data set for a dashboard)

As always thanks for your assistance as I plod along endeavoring to learn.
Jim