Thanks for the replies! Both of the last two posts produce solid output, and I really appreciate the effort. The last part of the equation is to take the minutes...

Thanks for the reply. Yes, the sum of completed tasks is needed; the last entry for each user will be open.

To concretely answer your question about the End Time - each entry "ends" the time spent on the previous entry; for example, 8:15am - 8:30am, (8:30am ends the 8:15am entry...

I can actually get close to where I think that I need to be. The problem with these results is that the first entry gets no time associated with it...

Thanks for the reply. Here is a quick example of some test data.

--Create a table to hold the data.

create table #tbl_Data (TimePunchID int identity(1,1), dateadded datetime, userid varchar(100), activity varchar(100))

--Populate...