title: Getting HH:mm version of total minutes in SQL
body: <p>I have a column which is a sum of total minutes users spend on a task. This column was got using:</p>
  
  <pre><code>(sum(cast(LTRIM(DATEDIFF(SECOND, 0, TotalTimeOtherTasks))as int)) over (partition by headLogs.operatorID)/60) as TotalTimeOtherTasks
  </code></pre>
  
  <p>This returns e.g 315.
  TotalTimeOtherTasks is a column of times for that task e.g 
  00:30:23
  01:05:55</p>
  
  <p>I want to make this show in HH:mm format so, 315 = 05:15.</p>
  
  <p>I've tried doing other answers for similar questions such as; using separate formulas and concatenating them but i get errors such as " '05:15' cannot be converted to an int " once it gets the answer or "':' is not recognized as part of the formula". If i convert it I then can't use sum(). So i think this might be its own question.</p>