Bi-Weekly Sum Data

I'm using this for tracking PTO time within a payroll period. (Sunday 12/24/17 - Saturday 1/6/18 is the first payroll period, then 1/7/18 thru 1/20/18 is the second period and so on).
Column A is Staff ID
Column B is Date of PTO use
Column D is Hours used.

I would like to figure out a way to do a sum after every payperiod and have a total of all hours used.
My current sheet is from 12/24/17 thru todays date.
Not everydate is listed on each sheet - only the days when PTO hours are used.
There are no zero's in the hours used.
I have the sheet separated by staff ID (all staff #40 are together, all staff #551 are together - etc.)

I'd love someone to point me in the right direction. Not sure if this can be done with just formuals? or VBA? - Thank you!

This can be done easily with formula's please provide an example of how your data is setup
sumifs formula wiht begin data and enddate should be no issue to build based on your layout..

Staff Entry
Date Hrs/Units

40
40 12/27/17 2.10
40 01/03/18 3.00
40 01/05/18 1.50
40 01/08/18 1.00
40 01/09/18 1.00
40 01/10/18 1.00
40 01/10/18 1.40
40 01/11/18 2.00
40 01/12/18 4.00
40 01/15/18 4.00
40 01/16/18 2.00
40 01/24/18 2.50
40 01/25/18 2.00
40 01/30/18 1.50
40 02/01/18 3.50
40 02/02/18 0.50
40 02/08/18 2.50
40 02/14/18 1.50
40 02/15/18 2.00
40 02/21/18 1.00
40 02/23/18 4.00
40 02/26/18 1.50
40 03/09/18 1.40
40 03/16/18 2.00
40 03/19/18 0.70
40 03/28/18 1.70
40 03/30/18 2.30

I kind off meant an excel exampe but this worked too this time

I changed some of the example data to apply to staffnumber 45 to prove the formula works on all changing dimensions.

Thank you! That is awesome.
I'll study up on SUMIFS. I'm following most of your formula - but not the end-from the quote marks to the end. - can you put that into words for me?
">="&$G3,$B$2:$B$28,"<="&$H3

I am looking for something similar. I have to keep track of employees total hours accumulated by pay period. They are only allowed to work a total of 1,000 hours in a one year timeframe, starting from their hire date. I need it to keep rolling over into the next year.
So, first column, the pay period (which is bi-weekly)..
Second column would be where I manually enter the number of hours they worked for that pay period..
Third column would be the total number of hours they worked that same time frame during the year before..
Fourth column would be the total number of hours they have left to work out of 1000 (or how many they've worked so far, one year from that date).
Any help is appreciated. If you have an excel sheet you could attach, that'd be perfect!