+ Reply to Thread
Results 1 to 3 of 3

Average hours across several weeks

  1. #1
    Registered User
    Join Date
    09-04-2012
    Location
    Texas
    MS-Off Ver
    Excel 2016, 2019
    Posts
    53

    Average hours across several weeks

    Timesheet sample.xlsxI have a time sheet that we are working but are often asked to compile data from it. We have most of the bugs worked out.

    The biggest issues now is to Average hours for the pay cycle. In our "Timesheet Sample" We can average each week (thanks FDibbins) as in the case of "Billy Bob" and we created a formula to average the 3 weeks that it spans, but as in the case of "Billy Jean's" she did not work one day each week so the formula gags on dividing zero.

    I need help in creating another formula that accounts for the average hours worked base on the days the worked not just the total days of the week. This is accomplished each week but when I cross from week to week it is not working out.

    All assistance is appreciated.
    Last edited by jaycee66; 10-24-2012 at 03:22 PM. Reason: Solved

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Average hours across several weeks

    How about adding an IFERROR function to the formula:

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    09-04-2012
    Location
    Texas
    MS-Off Ver
    Excel 2016, 2019
    Posts
    53

    Re: Average hours across several weeks

    Took some time away but Thanks to ConneXionLost, I got what I needed. Thanks again

+ 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