Change the cell's formatting. Either change it to something besides a time
format, or, go to custom format, and add on a message to display for negative
time.

So, let's say your current format is:
hh:mm:ss

Change this to:
hh:mm:ss;"Negative Time"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"puiuluipui" wrote:

Hi, i have this code:
=IF(ISBLANK(D9)," ",ROUND(((D9-C9-"08:30")-1/288)/TIME(,30,),)*TIME(,30,))

If the result is a negative time, then the formula display "###########".
Is there a way that this formula to display even the negative time or to
display a message instead of "#########"?
The message to be "Less"

Can this be done?
Thanks!