Help with adjusting formula so it does't calculate/display till all cells are filled in

Hi

I am trying to adjust an excel timesheet given to me. I have got a formula to calculate the broken turnaround, but I don't want it to calculate/display until two of the cells within the formula are filled in.

Otherwise it auto displays a negative number till they are filled in.

The formula I have is =SUM(D22 - C24 - 46800/86400) (where D22 is the time I leave say on a Monday night and C24 is the time I am called the next day say on Tuesday morning). The formula is calculating how many hours I break the 11 hour turn around.

I think it is the IF command but I have made several attempts to try to make it work but am completely stumped as it will not calculate and says I got the formula wrong.

Any help would be greatly appreciated.

Thanks

This has also been answered at https://www.mrexcel.com/forum/excel-...-complete.html --6SJ

Try:

Formula:

Please Login or Register  to view this content.

It can be done as one formula. What are the two formulae you now wish to combine? Maybe this:

=IF(OR(D22="",C24=""),"",ROUNDUP(SUM(D22 - C24 - 46800/86400),0))

Welcome to the Forum littlered136!

As a new member, please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires you to include a link if you post the same question somewhere else. I have edited your post to include the link this time because you are a new member.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

You're welcome. Thanks for the rep.