+ Reply to Thread
Results 1 to 4 of 4

Gnatt chart assistance/ time line graph

  1. #1
    Registered User
    Join Date
    12-12-2018
    Location
    High Wycombe
    MS-Off Ver
    Excel 365
    Posts
    2

    Gnatt chart assistance/ time line graph

    Good Morning/Afternoon/Evening

    I am new to this site and have turned to look for some assitance on a work project.

    I work in an emergency call centre. I am looking for a way to produce a daily 24hr sheet that shows in gnatt format the duty times of relevant call takers over a 24hr period split into 30 min blocks throughout the day. This so we have an easy visual tool to see how many call takers we have at any given time and to assist breaks and time out allocations. It needs to be on a one page layout.

    I have had varying success but struggle to deal with the after midnight periods where the chart throws out the graph after midnight until 07;00 am. CAn anybody assist in how to get an automated line chart from entering shift times. Also if its possible to add in additonal perioda to allow for breaks.

    Sounds a big ask. So a big up front thank you if anyone can assist or point me in direction of suitable tutorial.

    Thanks
    David

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,007

    Re: Gnatt chart assistance/ time line graph

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Do not try to use the Paperclip icon (Attachments button), as it does not work on this forum.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-12-2018
    Location
    High Wycombe
    MS-Off Ver
    Excel 365
    Posts
    2

    Re: Gnatt chart assistance/ time line graph

    i HAVE ATTACHED THE WORK TO DATE IN ITS BASIC STRUCTURE.I HAVE CONDITIONAL FORMATTED THE GRID TO REFLECT THE SHIFT START AND FINISHES. MY PROBLEM IS GETTING THE GRID TO POPULATE WITH THE SHIFTS THAT OVERUN THE MIDNIGHT PERIOD. I DID TREY TO CONVERT THE TIME BLOCKS TO NUMBER AND VLOOKED UP AGAINST THE TIME BUT THIS STILL DIDNT WORK BECAUSE OF THE DATE ISSUE. ANY SUGGESTIONS ???
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    6,473

    Re: Gnatt chart assistance/ time line graph

    Hello dacourt and Welcome to Excel Forum.
    This proposal changes the times in row 1 so that they do not include dates.
    The following Formula is then applied as a conditional formatting rule:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Look at rows 10:11 for examples of times that over run midnight and times that start and end after midnight.
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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