Forum Discussion
lukesi
Dec 27, 2025Copper Contributor
Calculating hours using pivot table
Hi,
I'm making a personell planning sheet and I want to calculate the sum of hours teachers give lessons. I have 2 tables and my data is formatted like this (simplified)
| Lesson name | Hours | Teacher 1 | Teacher 2 |
Lesson 1 | 2 | Paul |
|
Lesson 2 | 3 | Pete |
|
Lesson 3 | 2 | Paul | Pete |
| Teacher name | Max working hours |
| Paul | 10 |
| Pete | 15 |
Now I want to create an overview of how many hours each teacher is teaching using a pivot table.
This is easy when there is just one Teachter collumn but I need to calculate the sum using both teacher collumns...
I need to overview to be something like this:
- Paul -> Lesson 1 + Lesson 3 = 4 hours
- Pete -> Lesson 2 + lessen 3 = 5 hours
Then the next step is to use a metric or KPI to calculate if each teacher is exceeding their max working hours...
Can anybody hlelp me with these problems?
Thanks!
No RepliesBe the first to reply