Reporting: Time Filter

[AlexOnTheHill]

Hello,

I would like to produce a report for management that filters for specific time periods throughout the working week.

Ideally, I'd like to say show me all the calls to [x] department, not raised by self service, not in a cancelled status, logged between [time] and [time] over the course of the last year.

Do you have any recommendations for how I might achieve this? I have been going through the filters and nothing quite seems to match.

Theoretically, I could manually enter the specific time and date beginning and end date for each date manually but that isn't feasible.

Any recommendations would be gratefully received.

Many thanks

[AlexOnTheHill]

Rather than trying to achieve this through the reports I tried to extract all the data then filter for the timeframes using excel, that worked a treat.