PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Discussion Grand totals for summed time don't show >24:00

Reply

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

 
Thread Tools Rate Thread
Old 10-11-2006, 01:19 PM   #1
johan@aktieguiden.com
Guest
 
Posts: n/a
Default Grand totals for summed time don't show >24:00


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

  Reply With Quote
Reply



Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off