If formula that extracts data, needs update

MZING81

New member
Joined
Mar 27, 2012
Messages
40
Reaction score
0
Points
0
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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Why don't you post the workbook and tell us what the formula seeks to achieve?
 
Top