You could change the base date to 1904--but that will mess up your dates.

You could try tools|options|calculation tab|check "1904 date system"--but be
prepared to toggle it back after you see what it does with your dates.

The actual subtraction works fine--but the display will show ####'s.

So one way around it is to use two cells--one for the calculated value:
=a1-a2
(say in A3)
(hide this if you want)
Then use another cell A4(?) to show the results:

=IF(A3<0,"-","")&TEXT(ABS(A3),"[hh]:mm")

This cell is text, though--so use that intermediate cell if you need to do
further calculations.





DejaVu wrote:

Thanks Dave Peterson and Sloth -
That was exactly what I was looking for. I tried this several times,
but I could not get the hours to add days. I had my cell formatted as
*hh:mm*, and it wouldnt work. I changed it to *[hh]:mm* and it worked
perfectly!

One more question: What will happen if I end up with a negative time?
Say, for example, I have this:
A1: 10/16/05 17:55
A2: 10/15/05 11:30
A3: A2 - A1 = _____?_____

Thanks again,
DejaVu

--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=479280

--

Dave Peterson