Hello,
I've been using Access for quite some time but, do not consider myself an expert. I am completely stuck on something and need some help. I have a database where users enter in tickets. Part of their entry process includes entry date, time in and time out (meaning opening the ticket and closing the ticket).
Now I'm trying to report out total time spent for a user over the course of a day, week or month. My initial thought was this is easy, just use a min and max function and take the difference. That result is incorrect because it is possible that it will have gaps in time where no ticket was worked on. I can't seem to figure out how to calculate total time when times overlap and when there are gaps in time. Min and Mix seems to overstate the total times.
I was able to find a way to do this in Excel but that logic doesn't translate into Access because it refers to data in rows and Access doesn't view data in the same manner.
Any ideas? Am I making my question clear?
I've been using Access for quite some time but, do not consider myself an expert. I am completely stuck on something and need some help. I have a database where users enter in tickets. Part of their entry process includes entry date, time in and time out (meaning opening the ticket and closing the ticket).
Now I'm trying to report out total time spent for a user over the course of a day, week or month. My initial thought was this is easy, just use a min and max function and take the difference. That result is incorrect because it is possible that it will have gaps in time where no ticket was worked on. I can't seem to figure out how to calculate total time when times overlap and when there are gaps in time. Min and Mix seems to overstate the total times.
I was able to find a way to do this in Excel but that logic doesn't translate into Access because it refers to data in rows and Access doesn't view data in the same manner.
Any ideas? Am I making my question clear?