Note that TIME(32,0,0) does not work, time function only works up to 24
hours, so TIME(32,0,0) will return 8:00,
replace it with

--"32:00"


--

Regards,

Peo Sjoblom

"Issam LAdki" wrote in message
...
The formula below does not seem to work, can somebody please tell me that
is
wrong

Cell A1 = Time ,e.g. 12:30:00
Cell B1 is blank
Cell C1 = Time , e.g. 04:30:00
Cell D1 has following formula
=IF(C1<MOD(A1+TIME(32,0,0),1),"ERRe2,C1+TIME(7,0,0 ))
Basically is the time in C1 is less than A1 plus 32 hours, D1 will show
error otherwise it is D1 plus 7 hours.

I get the ERR in D1 if time is less, but not the D1 plus 7.

Can somebody please advise when am I going wrong, and thanks a lot for
your
help