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 muc...
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?
