LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred
 
Posts: n/a
Default Rounding to the nearest quarter (decimal) in a Pivot table

I tried posting this query a couple of weeks ago but my network crashed
and I have been unable to find the posting, so apologies if this is a
duplicate.

Each month I produce a pivot report of hours/days of work scheduled. I
would like to round the data part to the nearest quarter of an hour/day
(x.00, x.25, x.5 or x.75), I have seen and understand the principal of
MRound (and have the Analysis VBA toolpack addin) but can find no way
to apply this to a pivot table. I saw one posting that suggested
formatting the data cells but can find no way of specifying that I want
the above formatting applied.

Is there a way of achieving this kind of formatting to a Pivot report ?

Regards
Fred

 
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
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 05:32 PM
pivot table created from another pivot table Kreed Excel Worksheet Functions 6 October 26th 05 04:16 PM
how to delete/clean out the row list in pivot table john² Excel Worksheet Functions 1 May 26th 05 04:56 AM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Rounding number to the nearest quarter Dajana Excel Worksheet Functions 1 February 17th 05 02:21 PM


All times are GMT +1. The time now is 05:36 PM.

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

About Us

"It's about Microsoft Excel"