How to Calculate Total Minutes/Hours per quarter

[Anonymous]

Q1	Apr-Jun
Q2	Jul-Sep
Q3	Oct-Dec
Q4	Jan-Mar
Client	Start	End	Minutes a week	Q1	Q2	Q3
1	01/09/2022		45		yes	yes
2	01/09/2022		30		yes	yes
3	15/07/2021		270		yes	yes
4	15/07/2021		270		yes	yes
5	01/04/2022		45	yes	yes	yes
6	01/04/2022		60	yes	yes	yes
7	01/04/2022		30	yes	yes	yes
8	01/04/2022	04/08/2022	30	yes	yes	No	Calculation upto 04/08/2022
9	01/04/2022	04/08/2022	30	yes	yes	No	Calculation upto 04/08/2022
I want to be able to calculate the total number of minutes/hours per Quarter per client Thank you for your help!

[Greg_Deckler · Accepted solution]

@Anonymous Would probably be easiest if you unpivoted your quarter columns in your 2nd table. Then you could form a relationship between your 2 tables based on quarter and a simple SUM would suffice.