Convert seconds to HH:MM:SS

[Waffle]

Hi,

One of the field in my report have displayed value in seconds. I want it to convert in new field as HH:MMS. Is this possible. Can someone help me out?

Is there any idea for this?

[Rivita]

dateadd(second, [YourSeconds], [YourBaseDate])

[RasMus]

Try this:

TimeSpan myts = new TimeSpan(-555234423213113);

string myString = myts.ToString();

MessageBox.Show(myString.Substring(0, myString.LastIndexOf(".") ));

[CossFire]

I think you need to use this in the field.
Format(([Field1]/86400),"hh:mm:ss")

Hope this helps you.