Need help with IF statement

[AlanWade]

Hi,
I have in cell A1 start time e.g. 00:00
In cell B1 I have finish time e.g. 08:00
Now in cell C1 is lunch break which is always 30 mins (formatted as 00:30).
Is there an IF statement to hide the contents of C1 (00:30) unless there is a time entered in A1 and B1?

What I am trying to say is to only show the lunch break if I have entered a start and finish time.

Thanks for any help

Alan

 

[adam087]

Try
=IF(AND(A1<>"", B1<>""), TEXT(1/48, "hh:mm"), "")

Regards
Adam

 

[AlanWade]

Thankyou so much! Its perfect.

Many regards

alan

 

[AlanWade]

Spoke too soon!

What I hadnt noticed is that the cell displays correctly 00:30 for a thirty minute break but in a different cell I have this formula which works out the extra payment for nights: =IF(COUNT(C12:D12)=2;MOD(0,25-C12;1)-SUM(E12);"").
The extra payment stops at 6am, and I dont receive it during the break. But the formula now dosnt recognise my break anymore. Is there a way to make it recognise the cell that displays my break again?
This is the formula (as above) =IF(AND(C13<>""; D13<>""); TEXT(1/48; "tt:mm"); "") that enters the 30 minute break.

Thanks

Alan