Would like to Group by Hour

  • Thread starter Thread starter Brian Drab
  • Start date Start date
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.
 
I followed your instructions to the letter. Unfortunately I couldn't figure
it out based on the information provided.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum quantities per hour from inconsistent intervals on a 24hr cloc 4
Calculating productivity: widgets per hour 5
How do I convert hours, minutes, and seconds into decimal format? 2
How do I round time down to the nearest half hour? 3
Adding up total hours worked on employee schedule using various criteria 0
Adding Hours & Minutes 3
Transposing One Column to Multiple Rows 1
How do I sum column C based on a value in Column A? 2

Back
Top