Subtracting mm:ss.000

Feb 18th, 2002, 04:13 AM

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 · Feb 18th, 2002, 04:21 AM

Quote:

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.

Feb 18th, 2002, 04:49 AM

Thankyou - never heard of that before but it works!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 04:13 AM	#1
Guest Posts: n/a	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

Feb 18th, 2002, 04:49 AM	#3
Guest Posts: n/a	Thankyou - never heard of that before but it works!