LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mark@Marc
 
Posts: n/a
Default Summarize times in a pivot table


I have 3 columns.......date , name, and total time in 0:00 time format.
I want to use a pivot table to give me total time by date and name. It
appears pivot table will only summarize cells in number format. I am
new to pivot tables so please be gentle :)


--
Mark@Marc
------------------------------------------------------------------------
Mark@Marc's Profile: http://www.excelforum.com/member.php...o&userid=28126
View this thread: http://www.excelforum.com/showthread...hreadid=476377

 
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
Pivot Table for 3 columns of elapsed times William Elerding Excel Discussion (Misc queries) 0 October 14th 05 06:44 AM
Using Pivot Table Function to Summarize David Excel Discussion (Misc queries) 0 July 8th 05 04:46 AM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM


All times are GMT +1. The time now is 12:28 AM.

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"