How to get % as per cell based on the total hours of an employee in a range

[fayez_MrExcel]

In column C2(downwards), i need to calculate the percentage of hours(b2) as per the total hours of the Employee
eg. Employee John has a total hours of 240, then

1. c2 will have 42% (i.e. 100/240)
2. c4 will have 21%
3. c5 will have 9%
4. and so on

	A	B	C
1	Employee	Hrs	% per hour / per employee
2	John	100
3	Martha	56
4	John	50
5	John	20
6	Martha	70
7	Martha	25
8	Kevin	70

 

[steve the fish]

Like this:

=B2/SUMIFS(B:B,A:A,A2)

 

[fayez_MrExcel]

Thanks steve, have a great day ahead