CODEWITHSUNDEEP
reporting-servicesexpressionshoretel
Arron Robles
Arron Robles

Reputation: 283

SSRS Expression convert field to HH:MM:SS

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,

Upvotes: 0

Views: 1652

Answers (1)

Bactos
Bactos

Reputation: 1243

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.

Upvotes: 1

Related Questions