On Wed, 19 May 2010 12:57:01 -0700, Norm
wrote:

Thanks Ron
This worksheet will reflect what time the delivery is expected and what time
the delivery showed up ie. Est. arrival time vs. Actual arrival time I need
to show the varience whether the delivery is early or late by the number of
minutes (or hours)
I would like to see the varience in positive and negetive values
Does this make sense?
What would be the more usful formula?
Cheers!!!

My suggestion would be to include the date as well as the time in your Est. and
Actual columns.

Then, with a formula of

=Est - Actual

you will get a negative value if the delivery is late (i.e. Actual is after
Est).

If you format the cell as [h]:mm, you will get a result of hours:seconds.
However, you will need to select the 1904 date system in order that the
negative values display, and you will need to do this before entering the
dates, otherwise they will be off by four years and a day.

You could display the result, with the 1900 date system, as a text string, but
this would make subsequent math operations much more complex.



--ron