Help with Time in formula

[Bob]

=IF(F30="","",IF(F30<F31,90,F30*24*C30))
Is there a way to remove F31 (Which is where I have formatted to
"Time" and 1 inserted in it for 1 hour). What I need is... If F30 is
less than 1 hour, then insert 90, else F30*24*C30. I'm having a
problem as to how to write the time inside the formula. Something like
this... IF(F30="","",IF(F30<1HOUR,90,F30*24*C30)). Thanks in advance!!!

 

[Claus Busch]

Hi Bob,

Am Wed, 20 Jul 2011 13:59:19 -0700 (PDT) schrieb Bob:

Something like
this... IF(F30="","",IF(F30<1HOUR,90,F30*24*C30)).

try:
=IF(F30="","",IF(F30<1/24,90,F30*24*C30))

Regards
Claus Busch

 

[Bob]

Hi Bob,

Am Wed, 20 Jul 2011 13:59:19 -0700 (PDT) schrieb Bob:


try:
=IF(F30="","",IF(F30<1/24,90,F30*24*C30))

Regards
Claus Busch

Thanks so much, something so simple was so hard!!