subtraction with time format cells

[Stefano]

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?

 

[Bob Phillips]

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)

 

[Jason Morin]

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