fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 439
- Office Version
- 365
- Platform
- Windows
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
eg. Employee John has a total hours of 240, then
- c2 will have 42% (i.e. 100/240)
- c4 will have 21%
- c5 will have 9%
- 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 |