Hello all,
I am trying to calculate the time spent for each particular STATUS but when i do my pivot table (SHEET 7) it counts 12min compared to the reality from SHEET 5 where it should be 47min.
can you please help on this.
i have attached the excel as well
Bookmarks