<div>
ok, I understood. 
 
If I have this value &nbsp;'01:10', I should convert the value to integer and add to my dateadd. 
 
In this case, '01:10' how could I convert the value to integer in a correct way so the result would be 70?
</div>

<div>
In that case it will be 14:40 
 
No need to convert to INT. the function dateadd will automatically handle it. 
 

<pre><code class="code-10 nolinks" id="code-20-42349945-1">/*------------------------

declare @start_time time;
declare @elapse_time time;

set @start_time = '13:30:00'
Set @elapse_time= '01:10:00'

SELECT DATEADD(SECOND,DATEDIFF(SECOND,'00:00:00',@start_time),@elapse_time) AS finalTime
------------------------*/
finalTime
----------------
14:40:00.0000000

(1 row(s) affected)
</code></pre>
</div>

<div>
Pawan, 
 
declare @PREVISAO_INICIO datetime; 
declare @TEMPO_ESTIMADO &nbsp;varchar(10); 
 
set @PREVISAO_INICIO = '20171101 13:00:00' 
set @TEMPO_ESTIMADO &nbsp;= '001 00:30:00' &nbsp; -- ddd hh:mm:ss 
 
 
how to make this calc in MSSQL
</div>

<div>
Pawan, you helped me a lot. 
 
Thank you very very much
</div>

<div>
<div class="content wysiwyg-content">
Hello guys 
 
I have this code: 
 

<pre><code class="code-1 nolinks" id="code-10-29065694-1">declare @start_time time;
declare @elapse_time time;

set @start_time = '13:30:00'
Set @elapse_time= '00:30:00'

SELECT DATEADD(mi, @start_time, @elapse_time)
</code></pre>
 
How is the correct form? 
 
thanks
</div>
</div>

Hello guys

I have this code:

(CODE)

How is the correct form?

thanks

how to add minutes to my hours?

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.