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.