Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total
dear all
how i can total the no. of hours when Emp ID & date is matching with below row, till the row value is change either in date or Emp.No which coming first. thanks Date Emp #.ID No. of Hours 01/03/10 116 4.00 01/03/10 116 2.00 01/03/10 116 5.00 03/03/10 116 11.00 04/03/10 116 11.00 28/03/10 116 11.00 01/03/10 120 2.00 01/03/10 120 5.00 01/03/10 120 4.00 02/03/10 120 9.00 02/03/10 120 2.00 03/03/10 120 11.00 04/03/10 120 11.00 23/03/10 120 11.00 25/03/10 120 6.00 25/03/10 120 5.00 01/03/10 131 11.00 02/03/10 131 11.00 03/03/10 131 6.00 03/03/10 131 5.00 16/03/10 131 11.00 25/03/10 131 2.00 25/03/10 131 9.00 04/03/10 150 5.00 04/03/10 150 2.00 04/03/10 150 4.00 14/03/10 150 9.00 15/03/10 150 2.00 15/03/10 150 9.00 16/03/10 150 2.00 16/03/10 150 9.00 17/03/10 150 9.00 17/03/10 150 2.00 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total
I would be inclined to use a pivot table for that.
Data | Pivot Table or Pivot Chart... Follow the wizard. Drop the Employee # and Date into the left column with the hours in the data section. You end up with this... Emp #.ID Date Total 116 1/3/2010 11 3/3/2010 11 3/28/2010 11 4/3/2010 11 116 Total 44 120 1/3/2010 11 2/3/2010 11 3/3/2010 11 3/23/2010 11 3/25/2010 11 4/3/2010 11 120 Total 66 131 1/3/2010 11 2/3/2010 11 3/3/2010 11 3/16/2010 11 3/25/2010 11 131 Total 55 150 3/14/2010 9 3/15/2010 11 3/16/2010 11 3/17/2010 11 4/3/2010 11 150 Total 53 Grand Total 218 -- HTH... Jim Thomlinson "Yousoft" wrote: dear all how i can total the no. of hours when Emp ID & date is matching with below row, till the row value is change either in date or Emp.No which coming first. thanks Date Emp #.ID No. of Hours 01/03/10 116 4.00 01/03/10 116 2.00 01/03/10 116 5.00 03/03/10 116 11.00 04/03/10 116 11.00 28/03/10 116 11.00 01/03/10 120 2.00 01/03/10 120 5.00 01/03/10 120 4.00 02/03/10 120 9.00 02/03/10 120 2.00 03/03/10 120 11.00 04/03/10 120 11.00 23/03/10 120 11.00 25/03/10 120 6.00 25/03/10 120 5.00 01/03/10 131 11.00 02/03/10 131 11.00 03/03/10 131 6.00 03/03/10 131 5.00 16/03/10 131 11.00 25/03/10 131 2.00 25/03/10 131 9.00 04/03/10 150 5.00 04/03/10 150 2.00 04/03/10 150 4.00 14/03/10 150 9.00 15/03/10 150 2.00 15/03/10 150 9.00 16/03/10 150 2.00 16/03/10 150 9.00 17/03/10 150 9.00 17/03/10 150 2.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |