Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Again All,
I have a slew of dates and times (measured out as far as seconds) in a 12-month range, and they need to be grouped as "Rows where mm/dd/yy tt:tt:tt" is from 0:00 (midnight)-8:00am, 8:01am-4:00pm, and 4:01pm-11:59pm. I have an auxiliary column I've placed adjecent to this column, but I can't seem to get it done. Pivot Tables and grouping won't do it, because there are so many unique values (6000) that the pivot table simply won't generate. (I've attempted creating it 15 times using the Month column for rows and the d/t column for columns, and it goes through the pivot creation without issue, but when you click "Finish", nothing happens.) Any ideas? Thanks, Jamie (Guess it's time for me to start looking at the questions to see what I can help with, if only to offset my increasing number of requests. :) ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation source field size and function. | Excel Discussion (Misc queries) | |||
Using a field name in an IF function for a calculated field in a PivotTable | Excel Worksheet Functions | |||
how do i get field name from result of MAX or LARGE function | Excel Worksheet Functions | |||
Insert Function field? | Excel Discussion (Misc queries) | |||
vlookup and a function field input | Excel Worksheet Functions |