+ Reply to Thread
Results 1 to 1 of 1

Count Employees by intervals - scheduling

  1. #1
    Registered User
    Join Date
    04-05-2010
    Location
    Louisville
    MS-Off Ver
    Excel 2003
    Posts
    4

    Count Employees by intervals - scheduling

    Hello all!

    I've been pulling my hair out on an issue I am trying to solve in a workbook that I've designed to see how many workers are on the floor in a 24 hours period based on work schedules. One major issue is a 24 hour shift. I have 30 min intervals set up on the worksheet but can't seem to find how to count the number of employee past 23:59.

    Example:

    Monday
    Shift 1 - 0700 - 1500 - 5 workers ................ on the chart, formula would count 5 workers in 30 minute intervals from 0700 - 1500. And so on.....
    Shift 2 - 2000 - 0500 - 5 workers..... I can't figure out how to calucate 5 workers from 0000 - 0500 on 'Tuesday' morning.

    I've attached a sample workbook if anyone would like to see. On the right, is the work schedule key, where you can input schedules and then based on the times, need it to plot on the ghant chart (if you want to call it that) of the number of workers during the period.

    I appreciate any assistance!
    Attached Files Attached Files
    Last edited by bign1514; 09-29-2016 at 10:29 PM.

+ 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. Count Employees Working in Half Hour Intervals
    By shanewfm in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2015, 01:12 PM
  2. Scheduling employees - Countif formula building
    By Beh162 in forum Excel General
    Replies: 7
    Last Post: 01-20-2015, 06:38 PM
  3. Scheduling of employees
    By smokey43 in forum Excel General
    Replies: 2
    Last Post: 03-28-2014, 01:49 AM
  4. scheduling and hour tracking for multiple employees at multiple sites
    By nsswcd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2013, 11:32 AM
  5. Replies: 0
    Last Post: 05-07-2013, 08:45 AM
  6. Scheduling Employees: Linking Shift Times
    By zarlengp in forum Excel General
    Replies: 0
    Last Post: 09-22-2010, 02:30 PM
  7. [SOLVED] Scheduling employees by dates... LOOKUP or FILTER?
    By ssleene in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2005, 03:00 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