Some ranges in your SUMIFS are different: change all to row 14 to 41
B2=SUMIFS($G$14:$G$41,$B$14:$B$41,">=08:00:00",$D$14:$D$41,"<=16:30:00",$A$14:$A$41,B1)