+ Reply to Thread
Results 1 to 2 of 2

Adding Hours Worked on Employee Schedule based on varying daily criteria

  1. #1
    Registered User
    Join Date
    03-07-2016
    Location
    Washington DC
    MS-Off Ver
    2016
    Posts
    1

    Adding Hours Worked on Employee Schedule based on varying daily criteria

    I'm going to try to be as descriptive as I can, since I couldn't come up with a title that really explains my issue.

    I have an employee schedule that includes a column at the end of each week that gives the total hours worked by each employee for the week. The schedule uses shift codes rather than actual times.

    example 2.jpg

    Currently I'm using COUNTIF together with SUM in column G - =SUM(COUNTIF(B4:E4,{"OBA","OSA","NOMA","C","FL","SS1"})*{6,6,5,5,6,8})

    However, we now have schedules that vary daily, depending on the number of movements we have. On 3 movement days SS1=8, C=7, OBA=8, etc. On 2 movement days SS1=8, C=5, OBA=6, etc. I need to somehow add a function that uses the criteria in row 1 (MOVEMENTS) to determine what the value of the shift code is on that day, and then add the total weekly hours as it currently does. I can't change the format, so adding columns or rows isn't an option. I have thought about adding a worksheet that defines the values of each shift, but haven't been able to make that work either.

    Perhaps I'm over complicating it in my head and there's a very easy solution to this one.

    Thanks!

  2. #2
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    503

    Re: Adding Hours Worked on Employee Schedule based on varying daily criteria

    Try this

    I take that the extra work codes are SS2 and LL and copy down in G4

    Please Login or Register  to view this content.
    Last edited by Toonies; 03-07-2016 at 11:30 AM.

+ 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 Timesheet; calculating +/- hours worked
    By Somethingoranother in forum Excel General
    Replies: 6
    Last Post: 01-04-2016, 06:44 PM
  2. Creating an employee work schedule that will calculate time worked
    By Tlyke212 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-28-2015, 12:56 AM
  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. Replies: 8
    Last Post: 07-15-2013, 07:13 PM
  5. Replies: 0
    Last Post: 04-25-2012, 05:42 PM
  6. Calculating total overtime hours worked per employee
    By markjmcl in forum Excel General
    Replies: 3
    Last Post: 09-07-2011, 06:49 PM
  7. Tracking employee time and jobs worked on daily.
    By shawleigh in forum Excel General
    Replies: 0
    Last Post: 10-10-2005, 06:05 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