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?