+ Reply to Thread
Results 1 to 2 of 2

Excel Macro that sums total employee hours.

  1. #1
    Registered User
    Join Date
    07-05-2016
    Location
    Seattle
    MS-Off Ver
    2010
    Posts
    19

    Excel Macro that sums total employee hours.

    Hi all,

    The macro I am trying to write a macro that will add up each employee's total hours from a various number of projects for the current week and up to 8 weeks in the future.

    The tricky part is grouping the employees listed in one column and eliminating the duplicates and blank cells and then having the sum of total hours projected to work for each week listed next to the them in the respective column that corresponds with the correct week. There is another part that I am having trouble with too, which is sorting the engineer assigned hours from the CAD technician assigned hours (cells highlighted in sky blue).

    I have attached the Excel spreadsheet and would like the summary to be located below the list of projects, but locating it on a different sheet would work too.

    I have the "add project" and "new week" macros working perfectly.

    thank you!

    -norse
    Attached Files Attached Files
    Last edited by norseman1; 07-06-2016 at 10:56 AM. Reason: grammar

  2. #2
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2013
    Posts
    142

    Re: Excel Macro that sums total employee hours.

    I don't think a macro is necessary for the summary you're looking for. See attached sheet. I used a sumif formula with some named ranges that I think are accomplishing what you're looking for.
    Attached Files Attached Files

+ 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: 0
    Last Post: 03-02-2015, 07:59 AM
  2. Employee hours - total for each employee
    By 1joie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2014, 06:01 PM
  3. Formula to add total hours employee worked for each day.
    By rizmomin in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-23-2013, 06:10 PM
  4. Code for looking in Column A find employee ID and pull total hours worked
    By prdponce in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-27-2013, 04:37 PM
  5. Calculating total overtime hours worked per employee
    By markjmcl in forum Excel General
    Replies: 3
    Last Post: 09-07-2011, 06:49 PM
  6. Tracking the total work hours of each employee
    By Keerthivasan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2011, 03:53 AM
  7. Replies: 4
    Last Post: 06-02-2009, 12:20 PM

Tags for this Thread

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