Hello,
maybe someone can help me here:
A B C D
Member 1 Member 2 Member 3
1 01.05.2007 No. of Hours No of Hours No of Hours
2 02.05.2007 .... ....
3 03.05.2007
4 04.05.2007
5 05.05.2007
6 06.05.2007
7 07.05.2007
8 08.05.2007
9 10.05.2007
10 11.05.2007
11 12.05.2007
12 13.05.2007
13 14.05.2007
14 15.05.2007
15 16.05.2007
16 17.05.2007
17 18.05.2007
18 19.05.2007
19 20.05.2007
20 21.05.2007
21 22.05.2007
22 23.05.2007
23 24.05.2007
24 25.05.2007
25 26.05.2007
26 27.05.2007
27 28.05.2007
28 29.05.2007
29 30.05.2007
30 31.05.2007
The number of members and the month can vary.
The destination of my calculations are the following, one table per period:
01.05.07 - 15.05.07 Total No of Hours of all members
16.05.07 - 31.05.07 Total No of Hours of all members
And one table per calender week
CW 18 (01.05.07 - 06.05.07) Total No of Hours of all members
CW19 (07.05.07 - 13.05.07) Total No of Hours of all members
The input is changed every 4 weeks. So we should calculate first all periods in one year and then the formula for total number of hours for all members.
The same thing with the calender weeks. First calculate all calender weeks of a year and then calculate the formula for the corresponding total no of hours of all members for this calender week. I think I have to use If and lookup.
Does anybody know how can implement this in an easy way?
Regards
matti
maybe someone can help me here:
A B C D
Member 1 Member 2 Member 3
1 01.05.2007 No. of Hours No of Hours No of Hours
2 02.05.2007 .... ....
3 03.05.2007
4 04.05.2007
5 05.05.2007
6 06.05.2007
7 07.05.2007
8 08.05.2007
9 10.05.2007
10 11.05.2007
11 12.05.2007
12 13.05.2007
13 14.05.2007
14 15.05.2007
15 16.05.2007
16 17.05.2007
17 18.05.2007
18 19.05.2007
19 20.05.2007
20 21.05.2007
21 22.05.2007
22 23.05.2007
23 24.05.2007
24 25.05.2007
25 26.05.2007
26 27.05.2007
27 28.05.2007
28 29.05.2007
29 30.05.2007
30 31.05.2007
The number of members and the month can vary.
The destination of my calculations are the following, one table per period:
01.05.07 - 15.05.07 Total No of Hours of all members
16.05.07 - 31.05.07 Total No of Hours of all members
And one table per calender week
CW 18 (01.05.07 - 06.05.07) Total No of Hours of all members
CW19 (07.05.07 - 13.05.07) Total No of Hours of all members
The input is changed every 4 weeks. So we should calculate first all periods in one year and then the formula for total number of hours for all members.
The same thing with the calender weeks. First calculate all calender weeks of a year and then calculate the formula for the corresponding total no of hours of all members for this calender week. I think I have to use If and lookup.
Does anybody know how can implement this in an easy way?
Regards
matti