SSRS - How to AVG then format a number

Question

I'm trying to get the average handle time per call to display as HH:MM:SS.

What I can't seem to figure out is how to take the AVG(Field) and make it HH:MM:SS. I can either A) avg and get the a decimal number which represents seconds or format total seconds for all calls in HH:MM:SS. but can't seem to marry the two. I'm sure it's simple but can't find anything on here that works.

This was one of my attempts that didn't work. "=Format(Avg(Fields!AHT.Value), 'HH:MM:SS')"

Any help would be greatly appreciated!

Answer 1

You should be able to do something like ...

=DATEADD(DateInterval.Second, AVG(Fields!AHT.Value), Today())

then format this textbox as Time in the textbox properties, under 'Number' or use the format code T

This gives this result..

All the expression does is take Today() which is only the date (therefore the time is 00:00:00) and then add the average number of seconds to it. So the actual result is today's date plus the time we want. Then format the textbox as time only, to hide the date portion.