+ Reply to Thread
Results 1 to 2 of 2

Gantt Chart Formula

  1. #1
    Registered User
    Join Date
    Nashville TN
    MS-Off Ver
    Excel 2003

    Gantt Chart Formula

    I am using Excel to provide a Gantt chart for each route operated at this location. The formulas that I am using work perfectly as long as the start and end time are within the same day. However, in cases where a route starts in an evening and extends beyond midnight, the Gantt is not properly reflected. I need a formula that will work for all cases even when routes extend beyond midnight, properly reflecting the Gantt chart for each route's start and end time.
    I have attached a sample excel spreadsheet with a note highlighting one of the rows where the formula is not working properly to fit my needs. I could hard code the Gantt in but the user has the option to select the start time of the Gantt schedule so the formulas need to consider all routes that do and do not start and end within the same day.

    Thanks in advance for the assist!
    Attached Files Attached Files

  2. #2
    Forum Contributor bentleybob's Avatar
    Join Date
    Seattle, WA
    MS-Off Ver
    Excel 2010

    Re: Excel Gantt Chart Formula Issue

    Try this (in cell S14 and copied across):
    Please Login or Register  to view this content.
    Obviously, then copy it to other rows ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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