+ Reply to Thread
Results 1 to 2 of 2

Gantt chart display required with Start time & duration

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    6

    Gantt chart display required with Start time & duration

    Have data in time:

    Destination start time & Duration

    Duration 1 = 10:00 start & 03:00 hr duration
    Duartion 2 = 11:00 start & 04:00 hr duration


    Need to display Graphically like this
    ------------------ 09:00 10:00 11:00 12:00 13:00 14:00
    Destination 1-----------xxxxxxxxxxxxxxxxx
    Destination 2 -------------------- xxxxxxxxxxxxxxxxxxxxxxx
    Destination 3 ------------------------------- xxxxxxxxxxxxxxxxxxxxxx

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Gantt chart display required with Start time & duration

    It would help if you attached a sample Excel workbook, so that we can see exactly how your data is laid out - for instance, do you have the start time in one column and the duration in another (and if so, which columns)?.

    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.

    Please note that the Paperclip icon (Attachments button) does not work on this forum, so don't try to use that.

    Hope this helps.

    Pete

+ 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. [SOLVED] Formula incorrect to automate gantt based on start date and task duration
    By adam_d_john in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2018, 06:14 PM
  2. Replies: 7
    Last Post: 03-07-2018, 03:10 PM
  3. Replies: 2
    Last Post: 07-14-2015, 02:12 PM
  4. Excel 2007: Gantt chart showing incident duration
    By dobbinuk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-30-2014, 06:06 PM
  5. Start workday,Gantt chart
    By daredan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-29-2014, 07:18 AM
  6. Calculate finish time given start time, working hours and job duration
    By swanseaexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-23-2012, 03:00 PM
  7. Stacked Chart with start Datetime and duration
    By maks71 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-19-2009, 02:16 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