Would like to Group by Hour
 

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.

Would like to Group by Hour
 

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.

Would like to Group by Hour
 

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

Would like to Group by Hour
 

Hmmm... my "instructions" were brief indeed. Try

http://contextures.com/xlPivot07.html

In article ,
"Brian Drab" wrote:

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

Would like to Group by Hour
 

That worked. Thank you.