When I was calculating weekly pay, this is the formula I was using. I would simply filter to the week-ending in question and this would calculate the correct pay.
=IF(Table13[[#Totals],[HOURS]]>40,((Table13[[#Totals],[HOURS]]-40)*17.5*1.5)+(40*17.5),17.5*Table13[[#Totals],[HOURS]])

Now I'm switching over to biweekly. I want to filter the two week-endings, but calculate overtime as anything over 40 hours in one week. Any suggestions?

Sample.xlsx