Hi all,

I cannot figure this out.
I have 3 columns.
column A shows the Employee, column B shows the weekending and column C shows the amount of hours worked in that week.
like this:

A B C
Bill 04-may-07 40
Bill 11-may-07 38
Jake 04-may-07 56
Jake 04-may-07 60
etc.

Now in a period of 4 weeks the average may not exceed 55 hours per week(rolling period)
in a period of 16 weeks the average may not exceed 48 hours per week (rolling period)
I need to show these averages.
I really don't know where to start with this.
any help is appreciated.
Rob