first instance time based on date column

Hi,

I have data where I have a list of different agents and the times of their calls. what I want is to be able to enter a date and see what time the first and last calls were made by the specified agent or the first call made after a specified time if this is even possible?

Any ideas?

I have added a trimmed down version of data and lookup that I am looking for

Perhaps =AGGREGATE(5,7,(C2:C505="agent 1")*(B2:B505)) for first
and
=AGGREGATE(4,7,(C2:C505="agent 1")*(B2:B505)) for last

Hi Arthurbr, I am just getting value error on this? does this also specify the date as well as the agent?

Thanks
J

Hi Bo-ry - this does work but i need to be able to change the agent as there are multiple agents listed in the data - is this possible?

Thanks

J

Hi Bo-ry this is brilliant, does exactly what I need thanks

J