Convert minutes into hour and decimal in SQL
<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>