S
Sandy
Hi, I'm having trouble using the IF Function. Here's my problem.
In H4 I enter time data (time patient enters A&E ie. 07:13) and in K4 I also
enter time data (time patient leaves A&E ie. 09:42) then in L4 I have the
formula =IF(H4>K4,K4+1-H4,K4-H4) and this returns the time patient waited in
A&E. In N4 I have another formula thus =IF(L4>"4:00","Yes","No") however I
always get No as the answer. All I really want is the cell in N4 to tell
me if the patient breeches (ie. waited more than 4 hours in A&E).
Thank you
In H4 I enter time data (time patient enters A&E ie. 07:13) and in K4 I also
enter time data (time patient leaves A&E ie. 09:42) then in L4 I have the
formula =IF(H4>K4,K4+1-H4,K4-H4) and this returns the time patient waited in
A&E. In N4 I have another formula thus =IF(L4>"4:00","Yes","No") however I
always get No as the answer. All I really want is the cell in N4 to tell
me if the patient breeches (ie. waited more than 4 hours in A&E).
Thank you