+ Reply to Thread
Results 1 to 2 of 2

Gantt Chart Formula

  1. #1
    Registered User
    Join Date
    04-25-2011
    Location
    Nashville TN
    MS-Off Ver
    Excel 2003
    Posts
    2

    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
    02-27-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    643

    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)

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