Total

[Yousoft]

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

 

[Jim Thomlinson]

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