Multiple IF ISNUMBER SEARCH for multiple criteria and each column

[kenrin8885]

Hi, this is my first post here.
I have a sheet to calculate the working time.

The thing I want is that if Mr A is present in J9 & X9="Whole day" then his total working time is 7:00 and the result will be in V9.
On the 23rd if Y9="Morning" then his working time in V9 will be 10:30 and the same for other days.
If Mr B is in the same cell as Mr A then the calculation is the same as Mr A.
I've written a formula but the result was not correct.
<bdo dir="ltr">=if(or(and(ISNUMBER(SEARCH("Whole Day",X$9:AA$9)),ISNUMBER(SEARCH("Mr. A",$J$9)))),$AK$7,"0:00:00")

And if I have many employees and many working days then the formula will be very long. Is there a way I can optimize it?
Sorry for bad English.
Here is a picture of my sheet.
https://s18.postimg.org/yr53rpn15/attachment.png



</bdo>