PDA

View Full Version : Formulas to measuer four two criterias


KK1966
08-25-2008, 02:54 AM
Hi,
Anyone can help the formulas to measures the date and time as Cells A1 = actual successes Date 08/22 and B1 = time 12:00, to measures the commitments Date at E1 08/20 and F1 = commitment time 12:00,

Which formulas can count if anyone missed of the commitments = Failed else = Good jod.

Brother?s please help or suggest


Thanks
Bob Phillips
08-25-2008, 05:08 AM
=IF(AND(A1=--"2008-08-22",B1=--"12:00",E1=--"2008-08-20",F1=--"12:00"),"Good job","Failed")
KK1966
08-25-2008, 06:20 AM
Dear XLd,
Thanks for your help, but it does not fully work to my jod due to that's too many differents the commitments and differets time so, I had tying tp modify your formulas to the yyyymmdd and HH:MM !! does not be work go,


do any suggests
Pleased
Bob Phillips
08-25-2008, 06:46 AM
I have absolutely no idea what you are saying the problem is. A picture and a good example are worth a thousand words.
KK1966
08-25-2008, 07:00 AM
Dear XLD

Sorry my represent that's may let you confuse,
attached the samples, Pleased you help
Bob Phillips
08-25-2008, 07:07 AM
What are the results that you expect in column G? Seeing as all of E and F are the same, is this a good example?
KK1966
08-25-2008, 07:24 AM
Dear XLD

Actually the data almost 356XX Rows ...Which is part of smaple, the colume G want to cout which is failures to the commitments,

exactly here's
failed = WCM. else = Rcm.
KK1966
08-25-2008, 07:28 AM
Sorry the sample are not clear and rephrase again during the locations & areas to have log a differents commitments,

Do any formulas can facility,
Bob Phillips
08-25-2008, 10:00 AM
Sorry, I still don't understand what you want.
Aussiebear
08-26-2008, 03:37 AM
KK1966, What is it that you want us to assist you with?
Hi,
Anyone can help the formulas to measures the date and time as Cells A1 = actual successes Date 08/22 and B1 = time 12:00, to measures the commitments Date at E1 08/20 and F1 = commitment time 12:00,

Which formulas can count if anyone missed of the commitments = Failed else = Good jod.

Brother?s please help or suggest


Thanks

Cell A1 is not a date, but rather a product. Cell B1 is a name of a shop. Please re-construct your request, so that we have a cleared understanding of your issue.

We all have an issue with English, (especially those Americans),.... isn't that right Bob?:devil2:

Have another look at the workbook you posted, then re write your request, by referring to the correct cells, then we'll have another look at the problem