Check also http://forums.asp.net/t/1334046.aspx

>I need to return two values based off an elasped time. The first value (field) needs to represent the hours, the second the minutes but not total minutes. So if the elasped time was 62 minutes, I need the first value to be 1 and the second value to be 2. Right now I was doing it on the client side, but I need to have it in the stored procedure. I was hoping someone knew a way to do that cleanly.
>
>

>isnull(datediff(mi,meetings.ProcStart,meetings.ProcEnd),0) as TotalDurationMins,
>isnull(datediff(mi,meetings.ProcStart,meetings.ProcEnd),0) as HolderMins,
>

>
>
>Thanks
>
>Kirk