Greetings,

Sorry, wasn't sure which subforum to post this in, as there's nothing
dedicated to pivot table.

My dilemma is as follows:

I have a spreadsheet where data is entered daily. For my example, just
imagine a spreadsheet with three columns: date, date, delay. Two date
columns are used for the pivot table.

The pivot table is displayed with month and weekly ranges as the row
headers. There is a field in the pivot table that is summarized as a MAX of
one of the source data columns.

Now, the problem I am coming across is the monthly summary MAX is not
calculating properly. Pasted below is the pivot for the January test data.
You'll see that in the first week, the MAX for that week is 31:54. But in
the monthly summary, the MAX figure is showing 23:48.

Max of Delay
Month Date Total
Jan 1/1/2010 - 1/7/2010 0:31:54
1/8/2010 - 1/14/2010 0:26:41
1/15/2010 - 1/21/2010 0:24:44
1/22/2010 - 1/28/2010 0:23:48
1/29/2010 - 1/30/2010 0:03:03
Jan Sum 4:10:47
Jan Average 0:11:57
Jan Max 0:23:48
Jan Min 0:03:03
Grand Total 0:23:48


Why is the monthly MAX figure not 31:54? Am I overlooking something obvious?

Thanks in advance for any suggestions.

Brad