Lee

Goto toolsoptionsCalculation tabCheck 1904 date system. Be careful this
will display negative time but it will also change all other dates to be off
4 years and one day (I think). If this is not an issue then this should work
for you.

Mike Rogers


"Lee" wrote:

On Feb 2, 7:27 pm, ffjerm wrote:
when calculationing time, excel shows negative
time as "########", is there a way to change this default so the cell is
blank instead?

any suggestions would be appreciated - thanks

If, for example, the time is in cell A1, this equation will display
nothing when it is negative:

=IF(A10,A1,"")

Simply replace 'A1' in this equation with the function or calculation
you are using to arrive at the time, and it will display nothing for
any negative time.