The pressure rise between 8 am and 1 pm seems to coincide with the morning sun heating a blocked pipe causing thermal expansion. Water at ambient (20 to 25 deg C) temperatures can build-up pressures on heating by about 4-5 bar/
oC !
On the other hand, hammering is caused by a sudden conversion of the velocity of a fluid into pressure, resulting in a surge of pressure inside the piping.
As quark says, water-hammer happens by a sudden change in the rate of flow or stoppage of flow in the line in a short time, shorter than 2L/c, as with a valve. Where L is the length of the pipe under consideration, and c is the celerity of the pressure wave. The number 2 represents the wave travelling distance back and forth.
When the pipe is ductile (ie, deformable without rupture) the value of c depends on the Young modulus of the pipe as well as that for water. Assuming we speak of steel, the wave celerity in water at ambient conditions would be ~960 m/s.
If the length of the blocked pipe is, say 1000 m, the time of closure to create hammering should be shorter than 2*1000/964=2.08 s. Any closing quicker than that would appear as
instantaneous for the sake of this discussion.
Now, the pressure rise would depend on the fluid's velocity change, [Δ]V being stagnated. If, for example, the fluid travels at 1.1 m/s, the pressure increase would be:
(1000 kg/m3)(960 m/s)(1.1 m/s) = 1056000 Pa ~ 10.6 bar
The resulting tensile stress should be added to the designed value to verify that it ís still safely below the elastic limit of the pipe.
What kind of operation is carried out between 8 am and 1 pm ? Can you enlarge your system's description as quark asked you ?