+ Reply to Thread
Results 1 to 2 of 2

What to keep track of employee project hours to then do some calculations with the totals.

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    What to keep track of employee project hours to then do some calculations with the totals.

    I have been working on the attached spreadsheet, we have projects that our employees work on. I need to keep track of the hours spent on each. Then I need to combine this information so I can do some calculations, for example based on the total hours spent I can then work out the actual cost spend on the project versus what we have invoiced for this project, like a mini Profit and Loss on the labor only.

    I created a different worksheet per employee, I would like each employee to only be able to access there own worksheet, based on some protect or share worksheet rules. I created lists of Projects and Users, so this data is the same in each worksheet. Then I would like the data from each employee (only have 3 at this stage) to collate onto another worksheet, which only I can see, so I can do my total calculations etc. Along with hours, sometimes each project might have extras, this is charged at a certain rate per employee, so on the totals page I will also use this information.

    Here is what I have so far. Workings 150514 - sample for expert.xlsx

    Hopefully there is an easier way to do this. Thanks in advance.

  2. #2
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: What to keep track of employee project hours to then do some calculations with the tot

    Hi there,

    Not realy sure if this is what You except, but take a look at my solution.

    To get all the data from employee sheets, I used INDIRECT, but there is also a part that must be done manualy - in summary sheet, You have to copy all projects to all employees (see attachement).

    For visibility there is little VBA procedure for workbook_open event.
    You have to enter password. Passwords are "Corey", "Enrico", "Tom" and "Admin". (case sensitive)

    You can change it in VBA: Alt+F11 -> doubleclick on 'ThisWorkbook' and You will see:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Change the strings to anything You want for the users. Of course 'Admin' is Your password.

    So try it and let me know if some modifications are needed.

    Hope it helps

    Workings 150514 - sample for expert.xlsm

    (Do not forget to set password for VBA Project)
    Regards
    Miroslav R.

    (If You like my solutions, feel free to add reputation.)

+ 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. Employee hours - total for each employee
    By 1joie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2014, 06:01 PM
  2. Replies: 1
    Last Post: 02-06-2014, 08:12 PM
  3. excel spreadsheet that totals employee hours for the week
    By SCCULLEN in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-06-2013, 01:08 AM
  4. [SOLVED] Calculate employee hours for employee evaluation?
    By Triesha in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2006, 10:55 AM
  5. [SOLVED] What is the best way to Track Employee Absences on a spreadsheet?
    By Raysen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2005, 12:06 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