On Apr 2, 7:18 pm, ArthurN wrote:
Thank you,Spiky,
And how do I calculate the percent for each term?
ArthurN

Just normal math; Term 1 divided by the total of all 3 terms, and so
on. I suppose it starts getting a bit complex to read if you do all
these calcs in one formula, but you do already have the total in cell
B2...

Assuming your original picture above from your 2nd post, put this in
cell G2 for Term 1:
=ROUND(($C2/2)*(D$1*D2/$B2),0)*2

That should give you the breakdown of Term 1 extracurricular hours.
You should be able to copy that across to H2 and I2 to get terms 2 and
3 in those cells. And then you should be able to copy down so each
line can be it's own class. If I'm understanding what all you want.