Thread: Pivot Table
View Single Post
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

Let's say you have a column of data for NAME, PROCESS and TIME TAKEN

Select the cells of interest
Data - Pivot Table
Microsoft Office Excel list
Pivot Table
Select NEXT
Select NEXT
I prefer New Worksheet, but it's your choice.

Now comes the interesting part.

Select name and drag to the DROP ROW FIELDS HERE area
Select time and drag to the DROP DATA FIELDS HERE area
Right click on "COUNT OF TIME" and select FIELD SETTINGS. Choose SUM

"Ramki" wrote:

I have a list of names who have done a particular process and the time taken
for that process . The same persons might have done another process. I need
to add the time taken by a particular person for both the process together.
Eg. A has taken 10 min to do process 1, he has also taken 15 min to do
process 2. Hence on a day he has spent 10+15 which is 25 min.

I'm Using office 2000.