If formula that extracts data, needs update

I have this formula that is working fine, but now it needs to be updated to subtract one minute.

=IFERROR(IF('SCHEDULE WEEK ONE'!$I5="OFF","",IF(AND(ISNUMBER(SEARCH($P$16,'SCHEDULE WEEK ONE'!$K5)),SEARCH($P$20,'SCHEDULE WEEK ONE'!$C5),SEARCH($P$24,'SCHEDULE WEEK ONE'!$E5),SEARCH($P$28,'SCHEDULE WEEK ONE'!$F5),SEARCH($P$32,'SCHEDULE WEEK ONE'!$G5)),(RIGHT('SCHEDULE WEEK ONE'!$I5,5))+0,"")),"")


Tried to add it to the end within the RIGHT function but to no avail. I5 is what needs to have the one minute subtracted from it.

This is linked to a previous thread

http://www.excelguru.ca/forums/showthread.php?1075-Sumproduct-if-formula-to-ignore-text-string&p=4972#post4972

Thank you I appreciate any help

MZING81

Why don't you post the workbook and tell us what the formula seeks to achieve?