+ Reply to Thread
Results 1 to 3 of 3

Shift programm

  1. #1
    Registered User
    Join Date
    03-11-2023
    Location
    GR
    MS-Off Ver
    MS Officce 2019 and 2016
    Posts
    8

    Shift programm

    Good evening to the forum.

    I need your help with the excel concatenation.

    In short it is a Leave Program and I want to include in it a Shift Program.
    Let me tell you that I am a beginner in excel, and I completed the first part with a lot of help quite some time ago.
    I am asking for your help for the second part.
    I understand if someone doesn't want to get involved, because of the many parameters I'm asking for.

    It would also be good with functions and not vba, since the pc that will work is in a closed network with restrictions on vba. On my pc I have office 2019 but where it will work, it has office 2016 and below. Now if it can't be done with functions and requires code, let it be done with code.

    Shifts can generally be rolling or random. (I prefer the second).

    Inside the file, it is in Greek (columns, cells, etc.), as well as the formatting of the dates. The instructions I provide within the file are in English.
    I know it is a very difficult task.

    Thank you in advance.

    With regards / respect.
    Attached Files Attached Files
    Last edited by spmatrix; 03-12-2023 at 05:54 AM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: Shift programm

    It is confusing to me as to what is being attempted and where.
    Perhaps if some manually placed examples of the expected outcome were put into the file it would help us understand.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    03-11-2023
    Location
    GR
    MS-Off Ver
    MS Officce 2019 and 2016
    Posts
    8

    Re: Shift programm

    I want in the first image a formula, which automatically calculates for the whole year the shifts.
    The thing is, there are several parameters, according to the second photo.


    0st parameter:
    The list of names that will be doing shifts.

    1st parameter:
    The shift start date.

    2st parameter:
    The shift end date.
    When staff are dismissed they stop working shifts after this specific date.

    3st parameter:
    There are times when, for personal, family or other reasons, a member of staff is unable to perform a shift on a particular day.
    This day must be taken off, i.e. this day must not be counted in the shift formula.
    Syn even where the arrow points. It's staff leave scheduling. From the start date to the end date, excluding shifts.

    4st parameter:
    Not all staff work the same shifts. Here is the maximum limit of each staff that will be able to perform shifts.

    5st parameter:
    Here one of the staff does not like to work on Saturdays. Excluded from all Saturdays.

    6st parameter:
    Here one of the staff does not like to work on Sundays. Excluded from all Sundays.

    7st parameter:
    Here one of the staff doesn't like celebrating the holidays. Exemption from all holidays, according to the table of holidays shown by the arrow.
    Attached Images Attached Images

+ 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. Replies: 4
    Last Post: 04-27-2021, 11:49 AM
  2. Excel VBA Programm for School Student Database Management
    By betapsp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2014, 03:18 AM
  3. Caculating # of Day Shift Hrs & Night Shift Hrs of a Given Shift
    By DaKhoda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2014, 08:36 PM
  4. Excel programm for Copy a specifice cell
    By iamveru in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2013, 10:29 AM
  5. Creating an HR management excel programm. Need advices for formulas :)
    By Julien3000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2012, 09:59 AM
  6. how to create a programm to remove duplicates?
    By yogesh aggarwal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-22-2011, 09:03 AM
  7. [SOLVED] New Object - programm code
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2005, 08:05 AM

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