ServiceDesk Report Help
I'm trying to get a report set up that shows a list of all tickets by owner for the last week, including hours worked. I then want to show a total for each owner so something like:
- Job 1 - Job Title - 2 hours
- Job 2 - Job Title - 4 hours
- Job 3 - Job Title - 5 mins
Total for ONWER: 6 hours 5 mins
Any ideas on how to achieve this? SQL is not my strong point and whilst I can get the results back, I can't figure out how to sum the hours worked for each group.