Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables
Using a pivot table, I am trying to summarize my sales data into 15 minute
time periods during the day. Using a date/time format, I can only summarize by hour. When I format the times as numbers, I CAN get the grouping into 15 minute intervals, but the pivot table is difficult to understand, as it shows the intervals expressed as decimal numbers. Is there any way to convert these numbers to time formatted intervals? Any help would be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Ho to Delete "Ghost" Pivot Tables | Excel Discussion (Misc queries) | |||
Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |