Count values of a defined range in a pivot table column

On Sheet 1 you had a value error in J14 due to the length of cell I14 having 3 digits at the start. Corrected formula.
I have inserted a count of the records which are between 0-30 minutes (including 0 & 30).
Percentage does work of the un-filtered total, maybe not quite what you need.