If you use a pivot table, you can group by hours.

In article ,
"Brian Drab" wrote:

I have a column in my Excel spreadsheet that contains times. All the times
are for one day and always will be for one day only. I'm trying to subtotal
a particular column by Hour. The column has data in the following format:
0:00:31 (representing hour:minute:second)

When I click on the cell and look in the formula area it shows as 12:00:31
AM so it appears to be "understanding" the data properly.

How could I go about subtotaling a particular column by Hour?

Thank you.