+ Reply to Thread
Results 1 to 7 of 7

Averaging Time after using formula to determine time difference

  1. #1
    Registered User
    Join Date
    10-26-2014
    Location
    Tampa, FL
    MS-Off Ver
    2010
    Posts
    4

    Question Averaging Time after using formula to determine time difference

    I am creating a worksheet that utilizes a start time and finish time. I have been able to use =TEXT(D4-C4,"h:mm") to obtain the amount of time that has passed. Now I am trying to average that by the number of records/rows filled out (which I have totaled using =COUNTA(A4:A29)).

    For example:
    Column A is customer ID.
    Column C is start time
    Column D is finish time
    Column E is Amount of time.

    Further down the worksheet I have a summary section
    Number of Customers: =COUNTA(A4:A29) <-- Cell B33
    Average Length of Appointment: ?????

    Everything I've found online is either too basic or way over the top. Help!

    Thanks!

  2. #2
    Registered User
    Join Date
    10-26-2014
    Location
    Tampa, FL
    MS-Off Ver
    2010
    Posts
    4

    Re: Averaging Time after using formula to determine time difference

    I am open to other suggestions if there is an easier way to do this.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Averaging Time after using formula to determine time difference

    Am I missing the point, or have you made this more complicated than you need?
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  4. #4
    Registered User
    Join Date
    10-26-2014
    Location
    Tampa, FL
    MS-Off Ver
    2010
    Posts
    4

    Re: Averaging Time after using formula to determine time difference

    Possibly both. I don't know how many entries will be made per day in the worksheet. Since it will be variable, I used the COUNTA formula to determine how many records/rows were used. I would need the average times based on that COUNTA number.

    Here is the file with generic info.

    Exams.xlsx

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Averaging Time after using formula to determine time difference

    OK.... try this out.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-26-2014
    Location
    Tampa, FL
    MS-Off Ver
    2010
    Posts
    4

    Re: Averaging Time after using formula to determine time difference

    You're awesome! Thanks!

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Averaging Time after using formula to determine time difference

    You're welcome!!

    To keep things tidy, can you mark the thread as solved and (preferably), say thanks by clicking the Add Reputation button at the foot of this post?

+ 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. [SOLVED] Determine difference in time
    By lacke81c in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2014, 06:12 PM
  2. formula to determine what time double time starts and ends after 16:30
    By cfinch100 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-22-2013, 12:05 PM
  3. Replies: 21
    Last Post: 11-30-2012, 07:28 PM
  4. [SOLVED] Caculating the Time difference from Start & end date/time excludin weekends & non ofce hrs
    By Harry Jones in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-08-2012, 06:25 AM
  5. Averaging Time Difference
    By vldavis809 in forum Excel General
    Replies: 1
    Last Post: 07-08-2006, 04:45 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