IF statement using number formatting for cells

Hello all,

I am really stuck on this certain formula that I am trying to build. I am using a =IF statement

I need (if D6=B6), True= E6-C6, and False= D6-B6

I have the current IF Statement:

Please Login or Register  to view this content.

THIS IS THE CORRECT FORMULA, but I need= if True to have: number format cells set to h:mm:ss, and if False I need a whole number (for example= 4)

I was thinking of doing a =text formula inside the IF, but I am just confused and would be grateful for any help.

In that case you will need to use conditional formatting. The cell containing this formula would have the General (default) format. You would create a rule with a formula

=D6=B6

Then the format you apply would be Number, Time, h:mm:ss

Thank You, I kept inserting it right after I posted and the I kept forgetting the parenthesis. Thanks for the help


What would be an easy way to autofill this formula to the last cell in a vba?