Grand totals for summed time don't show >24:00

johan@aktieguiden.com

Guest

Posts: n/a

10th Nov 2006

I have a pivot table that sums time values. For the data items
everything is correct, but the grans totalt don't show time values
above 24 hours. I have the cell format [h]:mm, but it still doesn't
work.

What can be wrong?

I'm using Excel 2003.

// Johan

« how to get more than one highest values | Name range within a name range »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
doing math on summed totals	Repent	Microsoft Access Reports	7	10th Nov 2009 06:47 PM
how do I show grand totals for subtotals	rogbert	Microsoft Excel Misc	0	31st Mar 2009 07:04 PM
Pivot Totals: Group totals different from Grand totals	PsyberFox	Microsoft Excel Misc	1	13th Feb 2008 07:16 PM
Excel - how do I show column grand totals on the pivot chart	=?Utf-8?B?bmV3dXNlcg==?=	Microsoft Excel Charting	0	7th Mar 2006 03:30 PM
PivotChart, How to show Grand Totals in the chart?	=?Utf-8?B?S3Jpc3Rpbg==?=	Microsoft Excel Charting	1	5th May 2005 04:11 AM