Time on Task

Since the start and end times will be in the same row, it should be easy to compute the number of seconds between the two. Once you have the total seconds, you can convert that to any time format you wish. I'm thinking something like this:

SELECT UserName, SUM(DATEDIFF(SECOND, Start, End))

FROM CA

GROUP BY UserName

I hope I understand the requirement.

Thanks

Carl