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
=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