Opportunity Closed by Agent

Content

Hi,

I need to create a report which displays all the opportunity which are closed by particular agent during there logged in time.

Suppose if the agent is logged in for 2PM to 8PM and he has worked in 8 opportunities and closed 3 out of it,

The report should display 

Agent Name	No of Opportunity closed	Logged in time
ABC	3	6hrs0min0sec

I tried using transaction table but unfortunately it's giving me all the opportunities that has been worked and not only closed one.

We even need to bifercate this hourly basis.

Any help will be appreciated. Thanks in advance