With regards to the first part, I forgot to mention to format your cells
as 'Time'...

Hope this helps!

In article ,
Domenic wrote:

For the first part:

If your data spans more than 1 day...

=MIN(IF(A2:A12="Agent",IF(B2:B12="Logon",(C2:C12+D 2:D12))))

Otherwise, the following would suffice...

=MIN(IF(A2:A12="Agent",IF(B2:B12="Logon",D2:D12)))

Note that both formulas need to be confirmed with CONTROL+SHIFT+ENTER,
not just ENTER.

For the second part:

=SUMPRODUCT(--(A2:A12="Agent"),--(B2:B12="ACD
Incoming"),--(E2:E12="Q10556"))

Hope this helps!