danielvinhas
09-20-2011, 05:12 PM
Hello,
Can anyone help!!!
I’ve create a spreadsheetthat controls the hours of the teacher in a school, but if the teacher ischange for another in the middle of the period it still sums the previous teacher.
I'm trying to building adata base with the following information.
Teacher | discipline | begin| end
A X March Mai
B Y March June
C X Mai June
And in another data base I have
Date | discipline X |discipline Y | discipline Z
March 20 hours 10 hours 5 hours
April 10 hours 5 hours 15 hours
Etc…
I need to know how can I sumthe hours of the discipline X for the teacher A an the hours for the teacher Cthat has the same discipline but different dates.
Thank you kindly,:banghead: :banghead: :banghead:
Can anyone help!!!
I’ve create a spreadsheetthat controls the hours of the teacher in a school, but if the teacher ischange for another in the middle of the period it still sums the previous teacher.
I'm trying to building adata base with the following information.
Teacher | discipline | begin| end
A X March Mai
B Y March June
C X Mai June
And in another data base I have
Date | discipline X |discipline Y | discipline Z
March 20 hours 10 hours 5 hours
April 10 hours 5 hours 15 hours
Etc…
I need to know how can I sumthe hours of the discipline X for the teacher A an the hours for the teacher Cthat has the same discipline but different dates.
Thank you kindly,:banghead: :banghead: :banghead: