 <p>You almost get the answer from <strong>Matthew</strong>, all you need to do is to add cast :</p> <pre><code>Select CAST(SUM(timediff(timeOut, timeIn)) as time) as totalhours FROM volHours WHERE username = 'skolcz' </code></pre>