SUM Work Hours Between Two Dates

[bruntonomo]

I want to find how many hours each employee works between 7/3/2020 and 10/1/2020. This ExcelJet tutorial seems to show how to do what I'm trying to do. However, I can't seem to get it to work. I don't need it to figure out holidays. Our work week is an odd one as it runs Friday - Thursday. Attached is a spreadsheet of the hours each person works each day of each week. Can anyone adapt the formula so that it works?

Below is the formula the link gives:

=SUMPRODUCT(MID(D6,WEEKDAY(ROW(INDIRECT(B6&":"&C6))),1)*ISNA(MATCH(ROW(INDIRECT(B6&":"&C6)),holidays,0)))

 

[HappierThan]

You have weekly totals, you are looking at virtually 13 weeks. Is every week on a separate sheet, in the same format; i.e. Column I will always have weekly totals?

 

[KRice]

It appears that this is also posted here:

Hours Worked Between Two Dates

How would I go about creating a formula that looks at the attached spreadsheet and determines how many hours each person will work between two dates? In this case, the start date is Friday, July 3, 2020 and the end date is Thursday, October 1, 2020.

www.mrexcel.com

Here is a version that eliminates the helper rows:

Book1_20200606.xlsx
	A	B	C	D	E	F	G	H	I	J
1	From -->	7/3/2020	10/1/2020	<-- To
2		Fri	Sat	Sun	Mon	Tue	Wed	Thu	Weekly Total	Total hrs
3	name1	0	7	10	8	6	3	6	40	520
4	name2	10	3	8	3	0	12	8	44	572
5	name3	0	11	6	1	8	11	0	37	481
6	name4	6	5	4	8	5	9	4	41	533
7	name5	4	6	7	0	8	4	1	30	390
8	name6	0	2	1	11	12	7	11	44	572
9	name7	4	11	12	12	0	9	1	49	637
10	name8	4	7	10	7	11	12	4	55	715
11	name9	6	3	2	0	12	0	11	34	442
12	name10	0	12	8	8	0	0	1	29	377
13	name11	8	7	7	9	10	2	1	44	572
14	name12	0	4	0	0	11	7	3	25	325
Sheet3

Cell Formulas
Range	Formula
I3:I14	I3	=SUM(B3:H3)
J3:J14	J3	=SUMPRODUCT(INT((WEEKDAY($B$1-{6,7,1,2,3,4,5})-$B$1+$C$1)/7),$B3:$H3)

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).