If value in cell Then perform function

E

emm8080

Hi

Currently, I have the following function to convert the time into
number eg 17:55:00 returns 17.

=INT(D2*24)

I would like the function to first determine whether there is a time i
the cell ie if no value in cell then don't perform function.

Thanks

Emm
 
T

tjtjjtjt

=IF(INT(D2*24)=0,"",(INT(D2*24)))

This will make the cell appear blank, but you can't stop the Function for
Calculating.

tj
 
J

Jerry W. Lewis

=IF(ISNUMBER(D2),INT(D2*24),"")
Will not compute with blank cells, and will also not produce an error
with text cells.

Jerry
 
Top