+ Reply to Thread
Results 1 to 5 of 5

Calculating Man hours and days worked over multiple sheets

  1. #1
    Registered User
    Join Date
    07-08-2010
    Location
    Ontario Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Calculating Man hours and days worked over multiple sheets

    I'm trying to come up with a solution to calculate the man hours and days worked over multiple sheets.

    I have a file that has 8 sheets. the first seven sheets are the days of the week and the 8th sheet is where I want to calculate the hours.

    The days of the week consists of "Name" "Date" Hours"

    The 8th sheet consists of "Name", "Days of the week in their own column (7 columns in total)", "Total Hours" and "Total Days Worked"

    Now... each day is always a different group and what I'm hoping for is to create a formula that can grab each name with their hours and throw them into the 8th sheet. So when the end of the week is done I have all the Employees weekly hours and days worked all finished.

    I hope this makes sense. This file is to track about 100 employees that are on a rotational work schedule.

    I have attached a sample file.

    Thanks in advance for your help.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-08-2010
    Location
    Ontario Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Calculating Man hours and days worked over multiple sheets

    uhh... Hello? Anybody?

  3. #3
    Registered User
    Join Date
    07-08-2010
    Location
    Ontario Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Calculating Man hours and days worked over multiple sheets

    I'm getting discouraged. Is what I'm asking for too much or too easy or what? Could I please get some feed back.

  4. #4
    Registered User
    Join Date
    07-15-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Calculating Man hours and days worked over multiple sheets

    I am not sure how to totally automate it. You'd have to do that with a macro in VB or something. However, I do know this:

    If you list all employees' names in the final table to start with, then sort, then you could do vlookups for each name for each day of the week. Then use a countif funtion for the # of days paid. I attached the example back to you.

    Hope this helps!

    DJ
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-08-2010
    Location
    Ontario Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Calculating Man hours and days worked over multiple sheets

    Thanks DJ! I will definitely look at this. Thanks for your help.

+ 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