View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ArthurN ArthurN is offline
external usenet poster
 
Posts: 10
Default Need a function for my teaching plans

Hi,
I have the following challenge:
In my teaching a have to count the number of hours students spend on their
extra curricular activities.
This is the table I have:

classwork|extrawork|1stterm|2ndterm|3rdterm
16 weeks 15 weeks 17 weeks (per
term)
Psychology 188 120 4 6 2 (num of hours
per week)

What I know from this table is that, for example in the 1st term I will have
4 hours per week (actually two lessons, each 2 hours) 16 weeks which makes 64
hours or 32 classes per term. The total number of classes I will have in 1-3
terms is 188/2
What I don't know from this table is the number of extra curricular hours
per term/week. I know that the total is 120 and that each number should be
divided by two.

Could you help me out with this,
Thank you in advance,
ArthurN