<div>
<div class="content wysiwyg-content">
I have this part of code with provides hrs and minutes for two columns<br />
<br />
but i now need to add another colunm which is the total of the two fields<br />
<br />
so today i have<br />
hrmins &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bHrMin<br />
6:45 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 0:30<br />
0:45 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 0:00<br />
6:00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 0:30<br />
5:00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 0:30<br />
<br />
i would like<br />
<br />
hrmins &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bHrMin &nbsp; TotalMins<br />
6:45 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 0:30 &nbsp; &nbsp; &nbsp; &nbsp; 6:15<br />
0:45 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 0:00 &nbsp; &nbsp; &nbsp; &nbsp; 0.45<br />
6:00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 0:30 &nbsp; &nbsp; &nbsp; &nbsp; 5.30<br />
5:00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 0:30 &nbsp; &nbsp; &nbsp; &nbsp; 4.30<br />
&nbsp;<br />

<pre><code id="code-8241748">FLOOR((charge_split_1.duration + 1) / 60.0)) + ':' + RIGHT('0' + CONVERT(varchar, (charge_split_1.duration + 1) % 60), 2) AS hrmins, CONVERT(varchar, 
                      FLOOR(charge_split_1.break_time / 60.0)) + ':' + RIGHT('0' + CONVERT(varchar, charge_split_1.break_time % 60), 2) AS bHrMin,</code></pre>
</div>
</div>


I have this part of code with provides hrs and minutes for two columns

but i now need to add another colunm which is the total of the two fields

so today i have
hrmins	bHrMin
6:45	        0:30
0:45	        0:00
6:00	        0:30
5:00	        0:30

i would like

hrmins	bHrMin   TotalMins
6:45	        0:30         6:15
0:45	        0:00         0.45
6:00	        0:30         5.30
5:00	        0:30         4.30
 

adding to fields together

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.