Array formula to pull multiple numbers based on test

Hi all,

I have a payroll tracking workbook that has been very useful until now. The workbook consists of entry sheets (for entering # of hours and OT codes) and reporting sheets (to pull the # of hours from the entry sheet and instert into the correct column).
So far, so good. Problem is, I have run up against an unforseen issue - occassionally, an employee may require the entry of 2 different codes on the same day. The current formula cannot make that allowance and therefore misses 1 of the codes 9actually gets confused and pulls the wrong numer for 1 code and ignores the other completely). Regretfully, this is beyond my abilities.

Here is the current formula:

=SUM(IF(ISNUMBER(FIND(" "&Q$3&" "," "&'sheet1'!$AS61:$BF61&" ")),LEFT('sheet1'!$AS61:$BF61,FIND(" ",'sheet1'!$AS61:$BF61)-1)+0))+SUM(IF(ISNUMBER(FIND(" "&Q$3&" "&"P23"&" "," "&'sheet1'!$AE61:$AR61&" ")),LEFT('sheet1'!$AE61:$AR61,FIND(" ",'sheet1'!$AE61:$AR61)-1)+0))

*The second part of the formula (after the '+' - in blue) is just a copy of the first, giving the command to look back for the code for 'late entries' (P#)

Workbook attached - any help would be greatly appreciated! Getting desperate here