 <p>You can keep the uur and minuut values in a variable.Then get it formulated.</p> <pre><code>declare @hr int declare @mint int set @hr = SUM(dbo.kbpres.uur) set @mint = SUM(dbo.kbpres.minuut) SELECT (@hr*60 + @mint) / 60 as hours, (@hr*60 + @mint) % 60 as minutes </code></pre> <p>I think this will solve the prob please check</p>