Report - total worked time during given period of time

i need to make a report which will say what tickets in given queue given
users worked on (last month), and how much time did he work on it.

something like:

user: x
queue: y
month: 2008-11

ticket #123 - 123 minutes
ticket #344 - 20 minutes

and so on.

the problem is that, if user fills “worked” while registering
transaction (comment/reply) - it’s all simple.

but sometimes people forget about filling the field, and it’s just later
on, he/she manually changes “Time Worked” in “Basics” screen of ticket.

Is there any sane way to count total number of minutes per ticket,
regardless on whether it was put as “worked” in transaction, or by
changing “time worked” in ticket details?

Best regards,


Linkedin: / blog:
jid/gtalk: / aim:depeszhdl / skype:depesz_hdl / gg:6749007