Counting when a Time is within 30 minutes of a time in a different Column

1. Counting when a Time is within 30 minutes of a time in a different Column

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).

2. Re: Counting when a Time is within 30 minutes of a time in a different Column

Hi

Try in w2 and copy down.

Formula:
`Please Login or Register  to view this content.`

Same way for the others.

3. Re: Counting when a Time is within 30 minutes of a time in a different Column

Here is A different way to do it:

Column W: =IF((G2-B2)>TIME(0,30,0),"No","Yes")

Column X: =IF((G2-B2)>TIME(0,30,0),"Yes","No")

Column Z: =IF(AND(A2<B2,C2<B2),"Yes","")

Hope this helps

4. Re: Counting when a Time is within 30 minutes of a time in a different Column

Originally Posted by Cavinaar
Here is A different way to do it:

Column W: =IF((G2-B2)>=TIME(0,30,0),"No","Yes")

Column X: =IF((G2-B2)>TIME(0,30,0),"Yes","No")

Column Z: =IF(AND(A2<B2,C2<=B2),"Yes","No")

Hope this helps
Thanks, this has worked perfect. I just tweaked column W and Z to show results where the Dr time was equal to 30mins late or less and where the nurse saw the patient on as well as prior to their appointment respectively. Thanks for giving me the foundation and allowing me to tweak it that little bit. I really do wish I understood how to use excel.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1