Solved

# To add 30mins to the folowing formula

Posted on 2011-10-11
Medium Priority
257 Views
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.

Cheers
Rob.
0
Question by:RobJanine
• 4
• 2
• 2

LVL 61

Expert Comment

ID: 36953506
try

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

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

LVL 43

Expert Comment

ID: 36953515

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

Author Comment

ID: 36953518
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?
0

Author Comment

ID: 36953520
Sorry, too slow on my part.....Thanks
0

LVL 61

Accepted Solution

HainKurt earned 1000 total points
ID: 36953525

(...existing formula...)+IF(E5=1, (1/(24*60))*30,0)
0

Author Comment

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

LVL 43

Assisted Solution

Saqib Husain, Syed earned 1000 total points
ID: 36953544
0

Author Closing Comment

ID: 36953553
thanks to both of you....im having a bad day sorry.

Cheers
Rob.
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.