Results 1 to 8 of 8

schedule creator with rotating overtime and shift limits

Threaded View

  1. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,842

    Re: schedule creator with rotating overtime and shift limits

    Hello nolomcdc and Welcome to Excel Forum.
    The way the hours are entered will make a difference. However lets say that cell C15 contains 7a-3p;3p-11p. We could use wildcard characters in the COUNTIF function as in: =COUNTIF(C4:C19,"*"&$A32&"*")
    Note that 'on' has been removed from cells A32:A34.
    I will have to look at part two later if no one else has solved by then.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Rotating Overtime Schedule HELP!
    By MBowers2 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-28-2021, 01:18 AM
  2. Rotating Shift Schedule-Auto Populate
    By Gigem2000 in forum Excel General
    Replies: 1
    Last Post: 10-29-2018, 10:07 PM
  3. Rotating Shift schedule for 1 month
    By varun sarolkar in forum Excel General
    Replies: 0
    Last Post: 12-02-2013, 03:34 AM
  4. EOWEO 12 hour rotating shift schedule
    By moipaman in forum Excel General
    Replies: 0
    Last Post: 07-25-2013, 11:20 PM
  5. Replies: 16
    Last Post: 12-06-2012, 12:18 PM
  6. Shift Schedule - 3 Shift Coverage - Auto Populate Roll-up Summary Schedule
    By chips1256 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-31-2012, 09:32 AM
  7. Macro for a Rotating Shift Schedule
    By smck in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2005, 12:05 AM

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