On Sun, 8 Jul 2007 18:54:00 -0700, dknorwood
wrote:

I have a spread sheet that I use for time comparisons on a project. There
are target and actual times that get compared. I want to be able to show the
resulting difference as a positive or negative value. For example:

Target Time: 9:00 AM
Actual Time: 9:01:25 AM

I would like to be able to show tha result as + 01:45

I also need to account for the other situation as well:

Target Time: 9:00 AM
Actual Time: 8:58:25 AM

I would like thsi result to show as - 01:35

Any help would be most appreciated. I can definitely get the calaulation to
run ok, but I have not yet found a way to format the result in the desired
fashion.

dknorwood

If you can live with it:

Tools/Options/Calculations

Under Workbook Options SELECT the 1904 Date system.

Then format as mm:ss (or perhaps [h]:mm:ss.0) depending on how much precision
you wish to display.

This will change dates already entered in this workbook by 4 years (and a day),
but will allow you to display negative times.

Otherwise you would only be able to display the value as a text string -- that
would make further mathematical operations difficult. You might be able to get
around this issue by using hidden cells for the actual result, and visible
cells for the displayed result.
--ron