Formula

[TC123]

<TABLE id=post2653892 class=tborder border=0 cellSpacing=0 cellPadding=6 width="100%" align=center><TBODY><TR vAlign=top><TD style="BORDER-RIGHT: #ffffff 1px solid" id=td_post_2653892 class=alt1>Sorry to be a pain but I was also wondering if you could help me with one other small problem. I have 7 columns - A B C D E F G. In column G, I would like it to work out (in minutes) again what E2-A2 is (which is fine as I know how to do this now). However, I only want column G to work this out if columns B2 and D2 are empty. If they are not empty and have a figure I want column G to show 00:00. Does this make sense?

Thank you again
<!-- / message --></TD></TR><TR><TD style="BORDER-BOTTOM: #ffffff 1px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-RIGHT: #ffffff 1px solid" class=alt2> </TD><TD style="BORDER-BOTTOM: #ffffff 1px solid; BORDER-LEFT: #ffffff 0px solid; BORDER-TOP: #ffffff 0px solid; BORDER-RIGHT: #ffffff 1px solid" class=alt1 align=right><!-- controls --></TD></TR></TBODY></TABLE>

 

[TC123]

Bump

 

[anglais428]

=IF(AND(ISBLANK(B2),ISBLANK(D2)),"Your formula","00:00")

 

[TC123]

Thank you, that has worked and has returned 00:00 when the cells are not empty but has not worked when the cells are empty. I'm putting in the formula but nothing is happening, the cell is leaving the formula displayed.

I am entering =IF(AND(ISBLANK(B2),ISBLANK(D2)),"E2-A2*24*60","00:00") but nothing is happening. Is this correct?

Thanks

 

[shg]

Remove all the quotation marks, and change the 00:00 to just 0. Or

=IF(COUNTA(B2, D2), 0, E2-A2*24*60)