Working with dates and time
=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
|