<p>I am creating a chart that deals with hours and minutes. I have converted the times to int which returns the overall minutes.</p>
<p> </p>
<p>On the chart labels, instead of displaying the total minutes I would like to format it as Hour:Minutes which would be something like:</p>
<p> </p>
<p></p><pre class="_prettyXprint _linenums:0">SQL Command
CONVERT(INT, LEFT(time_stamp, 2)) / 60 + CONVERT(INT, LEFT(time_stamp, 2)) % 60
Javascript
row["time_stamp"] / 60 + ":" + row["time_stamp"] % 60
</pre>
<p> </p>
<p>I'm not sure where to put that, since it is summing these together based on timespan selection. Have any of you done something like this in the past?</p>
