If you want to make use of negative times you will have to switch to
the 1904 date system rather than the default 1900. However, this can
cause problems if you need to put the file on a system with 1900 as
the base - dates will appear to be 4 years and one day out.

Hope this helps.

Pete

On Mar 12, 1:38*am, vdmbqb wrote:
I have *times generated in h:mm in cell A1 and A2 I need a formula in A3 that
subtracts A2 from A1 and produces the difference (either negative or
positive) in h:mm.
For instance, the time in A1 is *6:15 and the time in A2 is 6:00 I need A3
to return -:15 or -0:15. All I can get is ###########.

Thank you in advance for any help offered.

--
bob