IF Function and length of wait query

[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

 

[Frank Kabel]

Hi
try
=IF(L4>TIMEVALUE("4:00"),"Yes","No")
or
=IF(L4>TIME(4,0,0),"Yes","No")

 

[Sandy]

Thanks Frank, it worked, you're a star

Hi
try
=IF(L4>TIMEVALUE("4:00"),"Yes","No")
or
=IF(L4>TIME(4,0,0),"Yes","No")