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

I tried that - the challenge comes in with it woun't recognise the pivot name as that can change - i.e your "PivotTable2"
Here is my code - you can see it says "PivotTable4" - also the end row could change so would be interested in your solution

Please Login or Register  to view this content.

Your solution put me onto a couple things. I added a couple declarations to the macro and changed all the "PivotTable4" to "MyPT" - i also had it clear the Pivot page of any pivots if they existed. I also changed the "Combined!R1C1:R246C6" to "Combined!R1C1:R500C6" to accommodate the change in rows (Is this the solution you were referring to?
Here is the code that seems to be working quite well.

Please Login or Register  to view this content.

Had a couple problems running your still with the name - not all got replaced - but added your LR code and works like a charm - really appreciate your time helping.
Jim