Projecting Rest Of Year Based Off Last 5 Pay Periods

I am struggling to figure out a formula that accurately projects work hours the rest of year based off the last 5 pay periods. My pay periods are in column I through column AH. The pay periods yet to come are blank with all previous entires with at least a 0 entered in them. In column F I have the actual total for the year so far and column G is where I am looking to have the projected number. So I guess I need the formula to average the last 5 pay periods and then see how many cells are still blank and then multiply the average by that number and add it to the actual total. Make sense? I hope so

Glenn,
Thanks for the reply. I would need a change to the formula though however. The issue is that I don't want anything entered in pay periods that have not happened yet, those cells are blank. I notice in your formula if I have them blank it will not calculate correctly. There may exist pay periods with a 0 obviously if the employee did not work, but I don't want to confuse managers with 0's in future pay periods. Is this a simple fix?

By the way that formula you created is crazy! I'm having trouble deciphering what it's doing, but whatever it's doing is working

Glenn,
You are the man! I have one more tough one for you . I have attached another version with the look my sheet will have. I also need to measure another period based off when the employee starts, We need to measure 26 pay periods from that day. As you can see in column H I have this figured out, but in the NEW column I need to measure the same way you helped me with the previous one. I think this is a simple change but wanted to make sure I didn't mess it up. You will notice that the conditional formatting on row 7 changes visually what constitutes one full year for the employee. It uses a black bar at the beginning and then extends the white area further over nn the right side of the sheet.

Sorry I messed up and used V2 as the base, your new formula is not in there. Just copy and paste your new formula in there (and shift I2 to J2)

Not an issue, thanks Glenn.

Hey Glenn,
thanks again for your help.
1. I want everyone's standard period to measure up to AI, this column will capture anyone that was already employed for the first pay period.
2. You are correct. The original version of this measured it based off the average and compared it to a full time equivalent of 80 hours per pay period.
3. This is the hard part. I need the formula to measure 26 pay periods starting from the first full pay period the employee begins in. so basically it starts after the "black bar" and measures out 26 pay periods. I needed to put all those pay periods in case someone started during the last pay period of the year and still needed to measure 26 pay periods from there.