Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Rounding number to the nearest quarter | Excel Worksheet Functions |