Subtracting mm:ss.000

[Guest]

Hi,
I'm trying to get the formatting right when I'm subtracting times e.g.
1:02.123 - 1:01.799.
The custom format of mm:ss.000 works ok apart from negative results.
Any ideas?
Thanks very much

 

[Aladin Akyurek]

On 2002-02-18 03:13, Anonymous wrote:
Hi,
I'm trying to get the formatting right when I'm subtracting times e.g.
1:02.123 - 1:01.799.
The custom format of mm:ss.000 works ok apart from negative results.
Any ideas?
Thanks very much

If negative results are also important to you, try switching to the 1904 date system on the Calculation tab via Tools|Options.

 

[Guest]

Thankyou - never heard of that before but it works!