CODEWITHSUNDEEP
asp.netrdlc
user150079
user150079

Reputation:

RDLC Expression to convert seconds in hh:mm:ss

need a expression to convert seconds into hh:mm:ss to use in a texbox of a local report (ASP.NET with Report Viewer)

Upvotes: 0

Views: 2395

Answers (2)

Bharath
Bharath

Reputation: 195

This works even if hour part is >24hrs.

=right("0" & int(sum(Fields!Total_Login_Seconds.Value)/3600),2) & ":" 
& right("0" & int((sum(Fields!Total_Login_Seconds.Value) Mod 3600)/60),2) & ":" 
& right("0" & (sum(Fields!Total_Login_Seconds.Value) Mod 3600) Mod 60,2)

Upvotes: 1

Saeedouv
Saeedouv

Reputation: 437

you can write a vb syntax code to make calculations within the report, choose report textbox value property and write your vb code there

Upvotes: 0

Related Questions