Real Time Log Question

[vsinne]

I have a table where we are tracking ticketing system. Some of these tickets takes longer to finish the job. These tickets may need multiple job to be performed and tracked by time to show how much time each person had spent on these tickets. In a way each ticket can have multiple time log that needs to be filled to show the productivity.

'

Question: I want to calculate the total time worked in by each person in a week. But my problem is if I want to calculate overall time for this week (If the tickets has been opened in January 2018 it would not show time for this week instead it shows the time for January.) how can I calculate actual time spent on all these tickets in current week than in the past week.

This is just the easier version of my table:-

ID	Name	Date Created	Status	Total Time
1	A	01/23/2018	Unresolved	2:30:00
2	B	02/28/2018	Unresolved	8:00:00
3	C	05/23/2018	Unresolved	5:00:00

[vsinne]

ID	Name	Date Ctreater	Status	Total Time Spent 5/23/2018 to 05/25/2018
1	A	01/23/2018	Unresolved	2:30:00
2	B	02/28/2018	Unresolved	8:00:00
3	C	05/23/2018	Unresolved	5:00:00

Result I am expecting

Total Time Spent this week = 15:30

Instead I have the result: 01/22/2018 to 01/26/2018 = 2:30

02/26/2018 to 03/2/2018 = 8:00

05/23/2018 to 05/25/2018 = 5:00

[Phil_Seamark]

Hi @vsinne

So have you already calculated the values in the [Total Time] column, or do you need these calculated?

And are you just after a SUM of the values in the [Total Time] column?

[Phil_Seamark]

Hi @vsinne

So for the three sample records, what would your expected result be?  Is it a DATEDIFF type calculation between the [Date Created] and today (taking into account weekends??)

[vsinne]

Yes i have calculated total time. In my case it calculates total time when ticket has been resolved. if ticket is unresolved in that case it is taking time in the month ticket has been created.  So it does not gives actual week data where the job has been performed instead it gives data based on Ticket date creation date.