Sum of hours between a range of dates

[jennyd88]

Don't know if this is possible but thought someone out there may have some ideas....
Making a holiday work rota and trying to get the sum of the hours taken between two dates
This is basically how it looks:
Sheet 1

Date	Rota hours
10/11/2017	10
11/11/2017	7
12/11/2017	10
13/11/2017	4
14/11/2017	6

<tbody>
</tbody>

Sheet 2

Holiday start date	Holiday end date	Total hours holiday
10/11/2017	13/11/2017

<tbody>
</tbody>

Total hours holiday would be the sum of column B between those 2 dates on sheet 1.

Anyone any ideas

 

[jennyd88]

Sorted, just used a SUMIFS formula

 

[jim may]

Excel 2010

	A	B	C
1	Holiday start date	Holiday end date	Total hours holiday
2	10/11/2017	13/11/2017	31

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula C2 =SUMPRODUCT((Sheet1!$A$2:$A$6>=Sheet2!A2)*(Sheet1!$A$2:$A$6<=Sheet2!B2)*Sheet1!$B$2:$B$6) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>