Conditional Format question

[Toonies]

Hi and thanks for taking the time to look at my question, which is

I am using this formula which works fine

=IF(E40>E43,"-","")&TEXT(ABS(E43-E40),"[h]:mm")

What I would like is when E40 and E43 are blank
I would like the answer cell E46 to be blank
(both cells are formatted to [h]:mm)

At present the answer cell E46 shows 0:00

I have tried conditional formating the cell to =0 but it still shows 0:00

Wondering if anyone has an answer.

Many thanks

Toonies

 

[nightcrawler23]

=IF(OR(E40="",E43=""),"",IF(E40>E43,"-","")&TEXT(ABS(E43-E40),"[h]:mm"))

 

[prajul89]

=IF(AND(E40="",E43=""),"",IF(E40>E43,"-","")&TEXT(ABS(E43-E40),"[h]:mm"))

Will this help!!

 

[Toonies]

Hi I've tried both and still get 0:00

many thanks for trying

 

[nightcrawler23]

Hi I've tried both and still get 0:00

many thanks for trying

Don no what is the problem... it does work for me

 

[prajul89]

I don't know whats wrong with both the formula it should display blank. I guess your E40 and E43 is never blank it must be zero I think.

if so this should help

=IF(AND(E40=0,E43=0),"",IF(E40>E43,"-","")&TEXT(ABS(E43-E40),"[h]:mm"))

See if this can do the trick!!!

 

[Toonies]

Hi that did the trick

Plus I used the following Conditional Formatting

=IF(E40>0,E40,"")
 
=IF(E43>0,E43,"")

Many thanks

Toonies