Forum Discussion
Real Time Log Question
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 |
4 Replies
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??)
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.
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
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?
