Turning Seconds in DD:HH:MM:SS

[mbryantuk]

Hi

Can someone help me turn the difference between a start date/time and end date/time into seconds in the format of DD:HH:MM:SS in my Reports

Thanks

Matt

 

[AlexCuse]

This is pretty nasty. I'd suggest putting the calculation into a custom assembly deployed to your report server for increased maintainability. I also have an FAQ in forum183 about how to do this in T-SQL.

= iif(Fields!sec.Value > 86400, ((Fields!sec.Value - (Fields!sec.Value mod 86400))/ 86400).ToString() & ":", "")
	+ Right("00" + (((Fields!sec.Value mod 86400) - (Fields!sec.Value mod 3600)) / 3600).ToString(), 2) + ":"
	+ Right("00" + (((Fields!sec.Value mod 3600)-(Fields!sec.Value mod 60)) / 60).ToString(), 2) + ":"
	+ Right("00" + (Fields!sec.Value mod 60).ToString(), 2)

Hope it helps,

Alex

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[AlexCuse]

btw, if you'd like to know how to do this in a Custom Assembly, take a look at this bit o' shameless promotion:

Using Custom Assemblies in SSRS

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page