excel - rounding down times

[nick]

I'm looking to set up a formula so that times in the
source cell are rounded down to the nearest hour.

eg
Source Cell A1 is 10:50am....the formula in cell B1 rounds
that down to 10am.
Source Cell A2 is 10:55....the formula in cell B2 rounds
that down to 10am.

The info in column B is then collated in a Pivot table
giving a per hour (10:00:00 thru 10:59:59) volume value.
In this case 2.

 

[Wild Bill]

TIME(HOUR(A1),0,0) will give you 10am in cell B1, though I can't speak
to your further operations with the pivot table.