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+B1>C1+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" <Ben@discussions.microsoft.com> wrote in message
> news:7E5A6359-6981-47AC-8F1F-E35081BD442F@microsoft.com...
> > 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
> >
>
>
>