+ Reply to Thread
Results 1 to 1 of 1

Scheduled staff per interval

  1. #1
    Registered User
    Join Date
    N Ireland
    MS-Off Ver

    Scheduled staff per interval

    Hi All, newbie here seeking some advice

    Attached is a schedule calculator I use for running shift scenarios, I punch the requirements from forecasting team into ‘calculator ‘ tab and then start building schedules on master tab. This is a simple ‘WhatIF’ calculator only problem is it requires a hugh amount of maintenance as I need to add new shift opens, example I have a 2pm-5:45pm shift option but not 2pm-6pm so to add I need to go in and add the shift and manually update the calculator. Wondering if anyone uses something similar? I would like to build a sheet that would allow any possible shift work hours. Haven’t been able to find anything so far.

    Thanks in advance
    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. Formula to Calculate number of staff scheduled between times
    By lspen00 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2017, 03:28 AM
  2. [SOLVED] Staff clock data conversion into time table per staff member
    By PhilSkil1609 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-02-2017, 04:33 PM
  3. [SOLVED] Count the number of staff working between times based on staff position
    By sparky1978 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2016, 08:10 AM
  4. [SOLVED] Macro to update Score Card Summary when the new staff add-in or existing staff deleted
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-12-2014, 02:43 PM
  5. Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet
    By Marie Snell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 11:04 PM
  6. Replies: 1
    Last Post: 10-31-2012, 10:11 PM
  7. Counting Scheduled Hours by Interval
    By grumpyrogue in forum Excel General
    Replies: 10
    Last Post: 12-06-2011, 09:22 PM


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