<div>
That did the trick. The field is a HH:MM time field so I replaced Not B with 0:00.<br />
<br />
Thanks for the help,<br />
<br />
Bill
</div>


That did the trick. The field is a HH:MM time field so I replaced Not B with 0:00.

Thanks for the help,

Bill

<div>
<div class="content wysiwyg-content">
I have the following formula in an Excel spreadsheet...<br />
<br />
=IF(OR(ISNUMBER(SEARCH(&quot;A&quot;<wbr />,H8)),ISNU<wbr />MBER(SEARC<wbr />H(&quot;T&quot;,H8))<wbr />)*AND(J8&gt;1<wbr />),CEILING(<wbr />SUM(C8-B8)<wbr />,&quot;0:15&quot;),)<wbr /><br />
<br />
I want to add the required condition that this formula only works if cell P8 contains the letter B
</div>
</div>


I have the following formula in an Excel spreadsheet...

=IF(OR(ISNUMBER(SEARCH("A",H8)),ISNUMBER(SEARCH("T",H8)))*AND(J8>1),CEILING(SUM(C8-B8),"0:15"),)

I want to add the required condition that this formula only works if cell P8 contains the letter B

Slight Modification to existing Excel formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.