title: How do I convert a float Value to Time in sql and get its sum?
body: <p>I have a column in table <code>TotalHours</code> which is of type <code>float</code>.</p>
  
  <p>The value are as </p>
  
  <ul>
  <li>3.4</li>
  <li>1.3</li>
  <li>4.2</li>
  </ul>
  
  <p>the format the hour column is following is like  <code>hours.min</code></p>
  
  <p>I want to get the total sum </p>
  
  <p>the query which i am using is as</p>
  
  <pre><code>select sum(TotalHours) as hours from workdone where userid = 3
  </code></pre>
  
  <p>so it is returning <code>8.9</code> which is wrong, first i need to convert it to hours and then take the sum but i am stucked.</p>
  
  <p>How do I get convert the values to hours and get sum?</p>
  
  <p><strong>Edited</strong>:The sum value will be in float format again. 
  For eg, the sum result should be <code>9.3</code></p>