+ Reply to Thread
Results 1 to 2 of 2

Using a pivot table to find total time spent in clinic

  1. #1
    Registered User
    Join Date
    05-20-2019
    Location
    Florida, US
    MS-Off Ver
    2018
    Posts
    6

    Using a pivot table to find total time spent in clinic

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,824

    Re: Using a pivot table to find total time spent in clinic

    Hi,
    A quick and dirty way.
    Add a column with the total time and the create the pivot table (see sheet 2 for an idea)
    Attached Files Attached Files
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you ( It doesn't hurt )

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1