<div>
You make it too complicated.<br />
Nobody presures you to have only one variable.<br />
Make TWO variables: one for formated user readbale output and the other as hidden variable only for internal sum calculation.
</div>


You make it too complicated.
Nobody presures you to have only one variable.
Make TWO variables: one for formated user readbale output and the other as hidden variable only for internal sum calculation.

<div>
<div class="content wysiwyg-content">
I have a report that I have to derive the DutyHours from two datetime fields (startdate &amp;&nbsp;end date). &nbsp;datediff(minute, min(s.arriveDateTime), max(s.departDateTime)) 'hours', &nbsp;I needed the total time to show in hour and minutes as 10.05 instead of 10.09 (decimal). &nbsp;I fixed this with &nbsp;convert(varchar(2), x.hours / 60) + ':' + convert(varchar(2), x.hours % 60).<br />
<br />
Now my problem is...how do I get my total hours. &nbsp;I can't SUM a string. &nbsp;I tried to use the timespan.parse in my field expression and that works great except that I don't need the seconds to show. &nbsp;Does someone know how to format the timespan option to show just HH:ss?
</div>
</div>


I have a report that I have to derive the DutyHours from two datetime fields (startdate & end date).  datediff(minute, min(s.arriveDateTime), max(s.departDateTime)) 'hours',  I needed the total time to show in hour and minutes as 10.05 instead of 10.09 (decimal).  I fixed this with  convert(varchar(2), x.hours / 60) + ':' + convert(varchar(2), x.hours % 60).

Now my problem is...how do I get my total hours.  I can't SUM a string.  I tried to use the timespan.parse in my field expression and that works great except that I don't need the seconds to show.  Does someone know how to format the timespan option to show just HH:ss?

How can I format timespan in field express to show just HH:mm

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.