Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |