Formula to calculate Specific dates and times

Good Day Everyone

Please assist I need to calculate specific times for specific days for Example
In my spreadsheet I have 10 entry's for 2015-09-01 in currently calculating the hours used Start time and end time but need a way to lookup the specific date and then calculate the hours spend for the date.

Regards
Anton

Sorry

I want to calculate all the time spend in the time spend per case for that specific day only
Below is the sample
Magistrate Name Court Seat(Venue) Court Date Case Number Parties Name Start End Time spent per case
dfg A 9/21/2015 12\04\2015 ABC 1:59 3:45 1:46
dfg A 9/21/2015 12\04\2016 ABC 2:59 4:45 1:46
dfg A 9/21/2015 12\04\2017 ABC 3:59 5:45 1:46
dfg A 9/21/2015 12\04\2018 ABC 4:59 6:45 1:46
dfg A 9/21/2015 12\04\2019 ABC 5:59 7:45 1:46
dfg A 9/21/2015 12\04\2020 ABC 6:59 8:45 1:46
dfg A 9/22/2015 12\04\2021 ABC 7:59 9:45 1:46
dfg A 9/22/2015 12\04\2022 ABC 8:59 10:45 1:46

Regards
Anton

Good Day Attached find the sample fileNew.xlsx

See attached with several (similar) formulae:

=SUMPRODUCT(($A$2:$A$15=A2)*(($B$2:$B$15="A")+($B$2:$B$15="B")+($B$2:$B$15="C"))*($E$2:$E$15)) for ALL Courts

=SUMPRODUCT(($A$2:$A$15=A2)*($B$2:$B$15="A")*($E$2:$E$15)) for Court A

A2 is the data (you may want to put a separate cell)