# Calculating Man hours and days worked over multiple sheets

1. ## 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.

2. ## Re: Calculating Man hours and days worked over multiple sheets

uhh... Hello? Anybody?

3. ## 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. ## 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

5. ## Re: Calculating Man hours and days worked over multiple sheets

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

##### Users Browsing this Thread

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

#### 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