#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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Tables venetianjigsaw Excel Discussion (Misc queries) 0 February 13th 06 02:51 PM
Dynamically changing several pivot tables at once Jason Excel Discussion (Misc queries) 3 December 16th 05 03:50 PM
Ho to Delete "Ghost" Pivot Tables needyourhelp Excel Discussion (Misc queries) 3 November 17th 05 10:10 PM
Problems with updating category names in pivot tables Vladimir Excel Discussion (Misc queries) 2 November 3rd 05 12:54 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM


All times are GMT +1. The time now is 09:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"