If value in cell Then perform function

[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

 

[Guest]

=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

 

[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