Hi,

I am looking for a formula that will look in a range of data for a particular state and then display the longest length of time in that state.

example

Talking 3:00
Idle 2:00
Talking 6:00
ACW 4:00

The formula I need woud be for 'Talking' and it would display 6:00 as the longest time in that state!
Thanks in advance
Brent