+ 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
    23

    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 2021 (Windows)
    Posts
    7,905

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table summarizing time spent per task per day from a task log
    By Fattyfatfat Kid in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-29-2019, 08:38 PM
  2. Total time spent over a term where monthly time reduces
    By dave0109 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2019, 07:13 AM
  3. Replies: 0
    Last Post: 03-04-2016, 06:38 PM
  4. Find total time spent out of "Geofence"
    By tgljl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-19-2015, 02:37 AM
  5. Calculating total time spent by half hour
    By sublime_01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2014, 06:25 PM
  6. Replies: 1
    Last Post: 10-27-2011, 11:43 AM
  7. total time spent for a specific employee
    By haylnut in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-14-2007, 02:38 AM

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