+ Reply to Thread
Results 1 to 8 of 8

Averaging the earliest start times and latest end times for multiple days

  1. #1
    Registered User
    Join Date
    05-26-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    29

    Averaging the earliest start times and latest end times for multiple days

    Hello,

    I am trying to find a way to average out the start time and end time for a week long period. The only problem is, there can be multiple start and end times in one day depending on how jobs were done that day. So I need to average the earliest start time for each day and the latest end time for each day for the whole time period, for multiple employees.
    I was able to work out the days worked, the times are the last piece that I need.

    I have attached an example.

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Averaging the earliest start times and latest end times for multiple days

    Since you not added the expected result. I take a guess.

    See the attached file, with a pivot table, solution.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    05-26-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    29

    Re: Averaging the earliest start times and latest end times for multiple days

    The attachment will not open.

    I'm sorry I forgot to mention that I tried using a pivot table before, but the pivot table columns may change which will mess up the end result.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Averaging the earliest start times and latest end times for multiple days

    You can open this attachement?

  5. #5
    Registered User
    Join Date
    05-26-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    29

    Re: Averaging the earliest start times and latest end times for multiple days

    I was able to get it open now. The end result I am looking for is to have the average start time and the average end time for the given time period. So for TECH 1 it shows they worked 5 days, but what is the average time they are starting their day and what is the average time they are ending their day?
    I can't use a pivot table because there may be some weeks where there are only five working days, some six and some seven.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Averaging the earliest start times and latest end times for multiple days

    Please add manualy the expected results in the file.

  7. #7
    Registered User
    Join Date
    05-26-2015
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    29

    Re: Averaging the earliest start times and latest end times for multiple days

    Actually the pivot table should work with the way it is created. I just applied an averageif formula and it's perfect. Thanks!

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Averaging the earliest start times and latest end times for multiple days

    Thanks for the rep.

    You're welcome. We appreciate the feedback!

+ 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. Replies: 21
    Last Post: 05-11-2015, 03:53 PM
  2. [SOLVED] Identifying earliest and latest times
    By Ron Purpura in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2014, 10:56 AM
  3. [SOLVED] Trying to extract multiple start and end times during the course of a few days.
    By kspeese in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-20-2014, 02:05 PM
  4. Replies: 3
    Last Post: 11-12-2012, 04:03 PM
  5. [SOLVED] Calculate time durations for a roster, and indentify the earliest and latest times
    By bajdr47 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-25-2012, 04:47 PM
  6. Replies: 0
    Last Post: 11-14-2011, 05:40 PM
  7. Averaging Times Across Days
    By gmscharl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-18-2008, 03:44 PM

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