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?
"Good News Everyone, by reading this your hearing my voice."
Last edited by Red_X_; 02-13-2012 at 09:43 PM..