Format_Text Formula Help

[larsocha]

I'm sure this is simple, but I am stuck...

I am using the following formula: =IFERROR(TEXT(D7-C7, "[h]:mm:ss"),"")

This works great in preventing the "#Value!" errors I get when "D" doesn't have a date/time.

The issue is that when neither cell has a date/time it returns 0:00:00...is there a way for the 0:00:00 to return a blank cell instead?

Thanks!

 

[JPARKHURST]

=IF(AND(D7>0,C7>0),TEXT(D7-C7, "[h]:mm:ss"),"")

Test against using an AND. I don't think you'll still need your iferror statement in there, but you can add it if there's somethign i've not thought of.

hth,

jON

 

[larsocha]

Seems to be working well so far.

Thank you!

 

[JPARKHURST]

Glad to hear it, and you're welcome!