I do not believe that this required an Automation. Can you explain the full question. Are you looking to have a table for all the pay periods then a summary of the hours worked by Employee (EE)?
If so I would create a table for all the pay periods, loading up with Excel with a key field which identified the YYYYMM1/2
for example
201901-1
201901-2
that would mean the par periods 1 and 2 for the 2019 January.
Then have each detail time entry self calculate which pay periods they calculate to by building a formula to make that text string.
Post back if you need help with the formula.