Thanks Bob
the formula works great,is it possible for when the answer is displayed the
text colour can change for example

Late - would be red
Early - would be blue
On-time - would be green

Thanks
Ben


"Bob Phillips" wrote:

=IF(A1+B1=C1+D1,"On Time",IF(A1+B1C1+D1,"Early by "&TEXT(A1+B1-(C1+D1),"d
""days ""hh:mm"),"Late by "&TEXT(C1+D1-(A1+B1),"d ""days ""hh:mm")))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ben" wrote in message
...
Hi,

Is it possible for a formula to calculate the diffence between seperate
cells.For example can A&B & D&E be read as one.The answer i'm looking for
in
F is LATE BY 1day 2hr. If they match to read ON-TIME, and if early to
read
EARLY BY and enter time

Expected Actual
Answer
A B D E F
05/03/2006 12:00 06/03/2006 14:00