View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rob
 
Posts: n/a
Default Excel won't allow times to be negative

I keep track of times in "mm:ss.00" format, and i've set up a formula that
deducts week B's time from week A's time - in order to show improvement. If
the time decreases week to week excel outputs a positive to represent this. I
would like it to ouput a negative number to represent increases in time.

Problem is, excel won't allow times to be negative - if they are it fills
the cell with "#" symbols.

Does anyone have any solutions to this.

Thanks