Convert seconds to hh:mm:ss format

Trying to convert a Time_Taken field that returns the number of seconds elapsed as a decimal into the hh:mm:ss format.  
=Format((Fields!Time_Taken.Value / 86400),"hh:mm:ss")

Open in new window

DotNetNoobyAsked:
Who is Participating?
 
GiftsonDJohnConnect With a Mentor Commented:
Hi,

I haven't noticed it should be on .rdlc file.

Please try this.

=String.Format("{0:HH:mm:ss}",CDate("0:0:0").AddSeconds(Fields! Time_Taken.Value))
0
 
GiftsonDJohnCommented:
0
 
GiftsonDJohnCommented:
Also you have some examples at

http://forums.asp.net/t/1212844.aspx
0
 
DotNetNoobyAuthor Commented:
I don't think I can create a function in the expression box within my .rdlc file
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.