asked on

To add 30mins to the folowing formula

Hi Experts,
I have the following formula below that an expert helped me with.
What I need to do now is if E5 = 1 then add 30mins to the answer from the below formula.
I have been trying for a while and cant seem to work it out. The formula below copies a time from another sheet if certin cells match by date etc.

=IFERROR(IF(INDEX('FP Reader'!$H:$H,MATCH(C$4&"|"&INT($A6)&"|"&$B5,'FP Reader'!$K:$K,0))="","",INDEX('FP Reader'!$H:$H,MATCH(C$4&"|"&INT($A6)&"|"&$B5,'FP Reader'!$K:$K,0))),"")

Cheers
Rob.

HainKurt

try

=A2+IF(E5=1, (1/(24*60))*30,0)

where A2 is the result for your formula above...
Book1.xlsx

Saqib Husain

simply add

+(e5=1)*30/24/60 to the end of the given formula

RobJanine

ASKER

Correct, but the formula and your formula need to be in the same cell eg C5.
I need to add 30mins to the formula result in that same cell.

Any ideas?

RobJanine

ASKER

Sorry, too slow on my part.....Thanks

ASKER CERTIFIED SOLUTION

HainKurt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

RobJanine

ASKER

when my formula returns a "" will it still try and add 30mins??
because once i inseerted your formula it returns "#####"