Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with reporting services and time conversion

Status
Not open for further replies.

wheels0323

Programmer
Oct 15, 2008
17
US
I need a way to convert this field into hh:mm

=Fields!TotalTimeSeconds.Value
It comes back as total seconds for a day.
I need to do this in reporting services somewhere inside the field textbox itself.

I was using
Convert(VarChar(2), sum(timeinseconds) / 3600) + ':' + Convert(VarChar(2), sum(timeinseconds) / 60 % 60) as TotalTime, in my SQL, but Iam unable to sum this field in reporting services. Yet, this field did come back the way I needed it.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top