I have three teams, Team C hours remains static @ 920. Therefore there are 700 hours left which automatically goes to Team A. However Team B may need some hours.

Is there a formula out there to help me from doing this manually?




Col A Col B Col C Col D Col E Col F Col G
Budget Team A Team B Team C
Hours % Hours % Hours % Hours
1,620 27.8% 450 15.4% 250 57% 920


Thanks for any assistance.

J