Hourly Pivot with Average values

Hi
In column [D] add a label : hour
In cell [D2] put the formula:
=HOUR(B2)
..and copy it down.
Now set your pivot table source range to the data block [A17201].
For the pivot table layout, drag field date to the row source.
Drag field hour to row source.
Drag field raw to the data area.
Change the data format from Sum to Average
The pivot table will then show hours from 0 to 23 with the average as required.
You will also get a daily average sub-total (which you can turn off)