title: Convert minutes into hour and decimal in SQL
body: <p>I have been referring this solution <a href="https://stackoverflow.com/questions/898658/format-minutes-into-hours-and-minutes-as-a-decimal-number-in-t-sql">Format minutes into hours and minutes as a decimal number in T-SQL</a></p>
  
  <p>but what I want is the value after decimal should represent the correct fraction?</p>
  
  <p>On converting 30 minutes to hours, this formula is incorrect </p>
  
  <p>select 30/60+(30%60)/100.0 --0.30</p>
  
  <p>where as the result should be:</p>
  
  <p>select 30*0.0166667</p>