Would like to Group by Hour

B

Brian Drab

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.
 
B

Brian Drab

I followed your instructions to the letter. Unfortunately I couldn't figure
it out based on the information provided.
 
Top