Hello everyone,
I am wanting to use a pivot table that shows how long each specific doctor spends in clinic on various days. I am familiar with pivot tables but I am not sure how to make it do what I want. If we look at Dr Joey for example, you can see he spent 7 hours and 23 minutes in the clinic. I want to use a pivot table to filter by the specific doctor and subtract the checkout time from the appointment time. I know I can manually calculate it but once more data is acquired, it would be much easier doing it this way if possible. It doesn’t have to be the exact way I said it. As long as you’re able to help me find the amount of time each doctor spends in the clinic, I will be happy. Thank you for the help.
Bookmarks