How to convert INT to HH: mm: ss using SSRS 2005

Question

Good. I need to display the total talk time of an agent that is included in SRSS 2005 with SQL 2005 as INT.

Throughout my life, I cannot understand which combination of expression editing or format editing I need to use.

For part of the part I can use: = DATEADD ("s", SUM (Fields! Talk_Time.Value), CDate ("00:00"))

And he will return: 1/1/0001 12:00:14 AM

Now I can use = LEFT (DATEADD ("s", SUM (Fields! Talk_Time.Value), CDate ("00:00")), 8)

who will return: 12:00:14

But I really need to: 00:00:14

Please, help!

Answer 1

12- , 12 "hh", 24- "HH".

ToString(), , ... 14 SUM (Fields! Talk_Time.Value)

=DATEADD("s", 14, CDate("00:00")).ToString("HH:mm:ss")

... 00:00:14

, 3 (10 800 )...

=DATEADD("s", 10800, CDate("00:00")).ToString("HH:mm:ss")

... 3:00:00

.

=DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")).ToString("HH:mm:ss")