How to calculate hours worked per pay period per employee?

I am helping with making a spreadsheet to help HR keep track of the OT hours each employee works each pay period.

My spreadsheet has the following relevant columns:

• B: Name
• H: Date
• I: Week #
• J: pay period (calculated biweekly)
• K: time start
• L: time end
• M: total hours

I am trying to create a summary page that will list the employees and then the pay periods (1, 2, 3.....) and just show how many hours they worked each pay period

I tried doing a pivot table, but it did not look how I wanted

Also, for column J, how can i make it so if there is not a value on column H it does not show -3286

here is the formula i used for the pay period

=INT((H6-DATE(2025,12,14))/14)+1