As described in this thread http://www.excelforum.com/excel-form...in-column.html I am conducting an audit in my clinic.
Last time I had a question the Forum helped me solve the problem in record time. I'm back with another question so that I can start crunching the resulting numbers.
I have attached a single sheet from my workbook and am looking for help populating columns W, X and Z.
Column W:
I would like this column to show "Yes" if Column G equals or is less than Column B + 30min. I.e. if the Dr sees the patient anytime before 30minutes after the appointment. I thought the formula would be =IF(G2=<(B2+00:30:00),"Yes","No") but this doesn't seem to work.
Column X:
I would like this column to show "Yes" if Column G is more than Column B + 30min. Again, I thought the formula would be =IF(G2>(B2+00:30:00),"Yes","No") but this doesn't work either.
Column Z:
I would like this column to show "Yes" if Column C is equal or less than Column B as long as Column A is less than Column B. I.e "Yes" if the nurse sees the patients on or before their appointment time as long as they booked in before their appointment (therefore not displaying late attenders). I can think of a formula in my head for this, but I don't know how I would put it into excel language).
Thanks in advance for any help you can offer.
Bookmarks