Help with SUMIFS/SUMPRODUCT Formula? for date/time

The first problem you have is that the times in Column B are text... Before you can do any time calculations you need to convert those to real Excel times. This function isn't elegant but it works :-)

=IF(RIGHT(B16,1)="m",(VALUE(LEFT(B16,FIND(":",B16)-1)+(IF(RIGHT(B16,2)="pm",12,0)))*3600*1/86400)+(VALUE(MID(B16,FIND(":",B16)+1,2))*60*1/86400),"")

Paste it down through the table starting from row 16

Then the formula from N3 down is :

=SUMPRODUCT((H$16:H$72>=L3)*(H$16:H$72<=M3)*E$16:E$72)