PivotTable Formula for Hours based on Days

[Kristylee0228]

Hello!
I have a DataSet with a Column for Days of Week: Mon, Tue, etc... What I am trying to do is create a formula for Scheduled Hours if Monday through Friday equal 8 hours, totaling 40. Saturday and Sunday would be 4 hours each. Having a total of 48 hours. I have searched and searched to no avail. Can someone please help. I am trying to put this in a Pivot Table.
Thank you so very much.

 

[etaf]

not sure what you are after, mayneed more detsail or a sample using XL2BB see signature

in the DATA Set
in a new column

=IF(WEEKDAY(A1,2)<6,8,4)

Book3
	A	B	C
1	1/1/21	Friday	8
2	1/2/21	Saturday	4
3	1/3/21	Sunday	4
4	1/4/21	Monday	8
5	1/5/21	Tuesday	8
6	1/6/21	Wednesday	8
7	1/7/21	Thursday	8
8	1/8/21	Friday	8
9	1/9/21	Saturday	4
10	1/10/21	Sunday	4
11	1/11/21	Monday	8
12	1/12/21	Tuesday	8
13	1/13/21	Wednesday	8
14	1/14/21	Thursday	8
15	1/15/21	Friday	8
16	1/16/21	Saturday	4
17	1/17/21	Sunday	4
18	1/18/21	Monday	8
19	1/19/21	Tuesday	8
20	1/20/21	Wednesday	8
Sheet1

Cell Formulas
Range	Formula
B1:B20	B1	=A1
C1:C20	C1	=IF(WEEKDAY(A1,2)<6,8,4)

 

[Kristylee0228]

not sure what you are after, mayneed more detsail or a sample using XL2BB see signature

in the DATA Set
in a new column

=IF(WEEKDAY(A1,2)<6,8,4)

Book3
	A	B	C
1	1/1/21	Friday	8
2	1/2/21	Saturday	4
3	1/3/21	Sunday	4
4	1/4/21	Monday	8
5	1/5/21	Tuesday	8
6	1/6/21	Wednesday	8
7	1/7/21	Thursday	8
8	1/8/21	Friday	8
9	1/9/21	Saturday	4
10	1/10/21	Sunday	4
11	1/11/21	Monday	8
12	1/12/21	Tuesday	8
13	1/13/21	Wednesday	8
14	1/14/21	Thursday	8
15	1/15/21	Friday	8
16	1/16/21	Saturday	4
17	1/17/21	Sunday	4
18	1/18/21	Monday	8
19	1/19/21	Tuesday	8
20	1/20/21	Wednesday	8
Sheet1

Cell Formulas
Range	Formula
B1:B20	B1	=A1
C1:C20	C1	=IF(WEEKDAY(A1,2)<6,8,4)

This works, however I was hoping to do it without adding anymore columns to the data. Like an IF statement within the Pivot Table. I have my Pivot Table data source connected to a View in SQL Server. Which I am new to as well. I honestly didn't think it was going to be this complicated. I appreciate your help!