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

Longest Wait Time	Service Level	Speed Of Answer	Avg. Wait Time	Avg. Abandoned Time	Greater than 5><
0:02:45	100.00%	0:00:48	0:00:00	0:00:00
0:00:06	100.00%	0:00:06	0:00:00	0:00:00
0:00:09	100.00%	0:00:06	0:00:54	0:00:00
0:00:06	100.00%	0:00:05	0:01:08	0:00:00
0:06:06	0.00%	0:00:00	0:00:00	0:06:06
0:02:12	88.89%	0:00:15	0:00:45	0:02:12

<tbody>
</tbody>

 

[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()