| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Would like to Group by Hour
That worked. Thank you.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Hybrid Mode
