Count IF and IF then Subtract two times in 24 hr Format to recieve time on task

[Snowbumms]

Hello Excel Masters!

I am totally out of my league but I have been doing my best with creating an excel formula but have miserably failed up to this point.

Here is what I am trying to do:

I get a spreadsheet downloaded to excel with a variable of 15 names.
I want to create a formula that if the name Cleardale appears to take the time responding in cell BD and subtract it from the time available in cell AV so that I have the time on task and then to add up all those times in a total time on task for all cleardale listings for that day. The times are listed in the 24 hour format. I keep getting errors. Can anyone help me out on this one? The range of the cells is from AV7 to AV500 for available time and BD7 to BD500 for alert time and the range of the names is cell f7 to f500. Please help!!!

 

[Snowbumms]

Did I explain it clearly? Its 3:30am in the morning here lol.

 

[Snowbumms]

Geeze,
It looks like it was just the formatting of the cells to change it from time to [h]mm:ss. I need sleep. Thank you so very much for your help!!