subtraction with time format cells
 

I cannot make the simple subtraction about 2 cells in a time format. e.g.
36.00.00-38.00.00 makes ######### while it works on the other way.
anyone can help me pls?

If the answer should be 2 hours use =ABS(A1-B1), if it should be 22 hours,
use =MOD(A1-B1,1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stefano" wrote in message
...
I cannot make the simple subtraction about 2 cells in a time format. e.g.
36.00.00-38.00.00 makes ######### while it works on the other way.
anyone can help me pls?

Excel cannot display negative date/time values. But you
can still use them in calculations. I would subtract the
values in 1 cell, hide this cell, and then use this
formula in another cell simply for display purposes:

=IF(A1-B1<0,TEXT(B1-A1,"-[hh].mm.ss"),TEXT(A1-
B1,"[hh].mm.ss"))

HTH
Jason
Atlanta, GA

-----Original Message-----
I cannot make the simple subtraction about 2 cells in a
time format. e.g.
36.00.00-38.00.00 makes ######### while it works on the
other way.
anyone can help me pls?
.