<div>
Hi,<br />
<br />
I think you have to write a simple VB.NET function to return the string. 
</div>


Hi,

I think you have to write a simple VB.NET function to return the string.

<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
Running SQL 2005 Reporting Services. &nbsp;I have a field in my report that shows total seconds. &nbsp;I would like to show that value as hours and minutes (ie 3:05 for 3 hours 5 minutes). &nbsp;Right now I have this expression:<br />
=(Fields!TIMEINSECONDS.Val<wbr />ue)\60) \60 &amp;&nbsp;&quot;:&quot; &amp;&nbsp;(Fields!TIMEINSECONDS.Valu<wbr />e)\60) \60) \60<br />
<br />
But this shows as 3:5<br />
<br />
Is there a better expression to accurately get what I want?
</div>
</div>


Hi all,

Running SQL 2005 Reporting Services.  I have a field in my report that shows total seconds.  I would like to show that value as hours and minutes (ie 3:05 for 3 hours 5 minutes).  Right now I have this expression:
=(Fields!TIMEINSECONDS.Value)\60) \60 & ":" & (Fields!TIMEINSECONDS.Value)\60) \60) \60

But this shows as 3:5

Is there a better expression to accurately get what I want?

Expression for converting seconds to Hours and Minutes in SQL Reporting

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.