SSRS Expression convert field to HH:MM:SS

Question

I am working on converting a Variable field to HH:MM:SS to display in a grid view. I am not sure how to write the expression. Can anyone assist?

Expression behind the variable is:

=Avg(Cdbl(IIF((Fields!ExitReason.Value = 7), IIF ((Fields!ExitReason.Value = 7), (Fields!DurationSeconds.Value) , (0)), 0)), "Group1")

Expression Variable is:

Variables!RACallsAbandonedAvPerGr3.Value

I am trying to convert to variable to HH:MM:SS an expression format in a grid field to display avg abandoned time. Example: Average Abandoned time 00:01:20

Thanks,

Answer 1

If you use X as your base time (the time you are converting) you can do the following:

Format(DateAdd("x", Variables!RACallsAbandonedAvPerGr3.Value, "00:00:00"), "HH:mm:ss")

Just be sure to substitute your x for: Hours = "h"
or Minutes = "m" or
Seconds = "s".

You have to pick one of the types.