dragonmouse
Board Regular
- Joined
- May 14, 2008
- Messages
- 129
- Office Version
- 2016
- Platform
- Windows
Code:
A B C D E
Job # Employee Hours Cost Percentage
1 M 0.9 317.22 32.97
1 C 1.83 317.22 67.03
2 M 0.9 385.77 49.72
2 C 2.42 385.77 72.89
3 C 0.91 210.32 50.28
3 M 0.9 210.32 49.72
Formula used for the PERCENTAGE column is =ROUND((($C7/SUMIF($A$2:$A$7,$A7,$C$2:$C$7))*100),2)
Last edited: