I have a table layed out for clocking in and out of a support ticket.

Currently the user will select if they are clocking in or out, and when they do it updates / adds a row for that user.

Now what I would like to do is add up the time taken for each of these tickets.

If bob clocks in at 9am and then finishes his work on it at 5pm. But then on the next day, jim clocks into the ticket and starts at 5am and goes to 10am. Which would be a total of what 13 hours on a support ticket.

So I guess my question is this

Is there a way to run a single query to get the number I need? Or am I going to extract each record and do it with a loop?

Thanks,

X

I've not done anything like that, but this may help.

http://www.sqlteam.com/article/worki...-in-sql-server

http://dev.mysql.com/doc/refman/5.5/...functions.html