Excel IF formula for time to create greater than or less than.

[Shinianne]

Hi,
I’m hoping someone can help me out, on the Greater than 5>< tab I would need it to appear as “>5” if it’s greater than 00:05:01 (HH:MM:SS) apparently VLOOKUP won’t work on it even though
It’s on the same format; your help is greatly appreciated

[TABLE="width: 878, align: left"]
<tbody>[TR]
[TD]Longest Wait Time
[/TD]
[TD]Service Level
[/TD]
[TD]Speed Of Answer
[/TD]
[TD]Avg. Wait Time
[/TD]
[TD]Avg. Abandoned Time
[/TD]
[TD]Greater than 5><
[/TD]
[/TR]
[TR]
[TD]0:02:45
[/TD]
[TD]100.00%
[/TD]
[TD]0:00:48
[/TD]
[TD]0:00:00
[/TD]
[TD]0:00:00
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]0:00:06
[/TD]
[TD]100.00%
[/TD]
[TD]0:00:06
[/TD]
[TD]0:00:00
[/TD]
[TD]0:00:00
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]0:00:09
[/TD]
[TD]100.00%
[/TD]
[TD]0:00:06
[/TD]
[TD]0:00:54
[/TD]
[TD]0:00:00
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]0:00:06
[/TD]
[TD]100.00%
[/TD]
[TD]0:00:05
[/TD]
[TD]0:01:08
[/TD]
[TD]0:00:00
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]0:06:06
[/TD]
[TD]0.00%
[/TD]
[TD]0:00:00
[/TD]
[TD]0:00:00
[/TD]
[TD]0:06:06
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]0:02:12
[/TD]
[TD]88.89%
[/TD]
[TD]0:00:15
[/TD]
[TD]0:00:45
[/TD]
[TD]0:02:12
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[etaf]

if whats greater than 5?
and vlookup, are you only entering this once for any of the values in the list?

longest Wait time = 6.06 , so thats the only one greater than 5 - would that appear in the same row - or ?

if just in every row
you could use MAX() on column A, C , D , E = if you want to flag any of those events

if( max ( a2 , c2 , d2 , e2 ) > 5.01 , "> 5" , "")
may need to use TIME()