Thread: pivot tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bentley
 
Posts: n/a
Default 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!