3 Cell formula calculation based on Dates

[Huizar]

All,

I have been working on this formula for a bit and am struggling it to finish it of.

I have 3 cells that consist of Date/Time stamp H, I, J: My formula below:

=IF(AND(ISNUMBER(J2),ISNUMBER(H2)),(J2-H2)*1440,IF(AND(ISNUMBER(J2),ISBLANK(H2)),(J2-I2)*1440))

But I want to included that if cell J2 is "Blank", then deem the cell "No ETA".

Help is greatly appreciated.

 

[Fluff]

Maybe
=IF(J2="","No ETA",IF(AND(ISNUMBER(J2),ISNUMBER(H2)),(J2-H2)*1440,IF(AND(ISNUMBER(J2),ISBLANK(H2)),(J2-I2)*1440)))

 

[Huizar]

Maybe
=IF(J2="","No ETA",IF(AND(ISNUMBER(J2),ISNUMBER(H2)),(J2-H2)*1440,IF(AND(ISNUMBER(J2),ISBLANK(H2)),(J2-I2)*1440)))

Fluff,

Wow, so simplistic. Worked Great. Thanks

Huizar

 

[Fluff]

You're welcome & thanks for the feedback