software

I keep track of times in quot;mm:ss.00quot; 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 quot;#quot; symbols.

Does anyone have any solutions to this.

Thanks

not exactly sure, will this help:

=IF(xlt;0,-(calculation),calculation) (neg,pos)

quot;robquot; wrote:

gt; I keep track of times in quot;mm:ss.00quot; format, and i've set up a formula that
gt; deducts week B's time from week A's time - in order to show improvement. If
gt; the time decreases week to week excel outputs a positive to represent this. I
gt; would like it to ouput a negative number to represent increases in time.
gt;
gt; Problem is, excel won't allow times to be negative - if they are it fills
gt; the cell with quot;#quot; symbols.
gt;
gt; Does anyone have any solutions to this.
gt;
gt; Thanks

Toolsgt;Optionsgt;Calculation: 1904 calendar

HTH
--
AP

quot;robquot; gt; a écrit dans le message de
...
gt; I keep track of times in quot;mm:ss.00quot; format, and i've set up a formula that
gt; deducts week B's time from week A's time - in order to show improvement.
If
gt; the time decreases week to week excel outputs a positive to represent
this. I
gt; would like it to ouput a negative number to represent increases in time.
gt;
gt; Problem is, excel won't allow times to be negative - if they are it fills
gt; the cell with quot;#quot; symbols.
gt;
gt; Does anyone have any solutions to this.
gt;
gt; Thanks
Changing to 1904 calendar affects many things and isn't always desirable.

How about doing something like

=IF(A1gt;B1,A1-B1,B1-A1)

and then in an adjacent cell add

=IF(B1gt;A1,quot;Decreasequot;,quot;quot;)

or even use conditional formatting to show decreases.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Ardus Petusquot; gt; wrote in message
...
gt; Toolsgt;Optionsgt;Calculation: 1904 calendar
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;robquot; gt; a écrit dans le message de
gt; ...
gt; gt; I keep track of times in quot;mm:ss.00quot; format, and i've set up a formula
that
gt; gt; deducts week B's time from week A's time - in order to show improvement.
gt; If
gt; gt; the time decreases week to week excel outputs a positive to represent
gt; this. I
gt; gt; would like it to ouput a negative number to represent increases in time.
gt; gt;
gt; gt; Problem is, excel won't allow times to be negative - if they are it
fills
gt; gt; the cell with quot;#quot; symbols.
gt; gt;
gt; gt; Does anyone have any solutions to this.
gt; gt;
gt; gt; Thanks
gt;
gt;