LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
training plans sherif Excel Discussion (Misc queries) 1 October 4th 07 09:07 AM
Pro Rate Billing Template for wireless plans Jean Excel Discussion (Misc queries) 4 March 13th 07 04:21 AM
npv calc for customer pay plans Juan Valdez Excel Worksheet Functions 1 September 25th 06 03:02 AM
automatic time plans jammy20466 Excel Discussion (Misc queries) 0 June 27th 06 09:34 AM
is there a way of drawing floor plans within office madge New Users to Excel 7 April 6th 06 08:02 PM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"