Help with SUMIFS/SUMPRODUCT Formula? for date/time

Trying to create a formula that will grab the #total calls (successful+no answer) to 30mins interval. Also need to find out if these calls falls under weekday or weekend.
Not sure if this should be a a SUMIFS or SUMPRODUCT? desperately need help.
Raw data is extracted and pasted over Col A-G (so would prefer if there's no manipulation required to these columns each time data is extracted and pasted over).

Any advice or assistance would really be good. Thank you in advance