+ Reply to Thread
Results 1 to 2 of 2

Need to change Gantt chart to track hours in a day through Monday - Friday

  1. #1
    Registered User
    Join Date
    09-19-2023
    Location
    united states
    MS-Off Ver
    microsoft exchange 365
    Posts
    1

    Need to change Gantt chart to track hours in a day through Monday - Friday

    Nees to change the existing template of the Gant chart to track tasks by hours in a day in increments of 15 or 30 min. Gant chart currently has existing formulas tracking weekly progress
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Need to change Gantt chart to track hours in a day through Monday - Friday

    Your question is not clear with respect to this file. It does not have any formulas that track progress, and there is nothing weekly here. The calendar starting in column I is grouped by week, but it does not track weekly progress, it tracks daily progress. You must manually enter percent progress in column D. The shading starting in column I shows progress based on that percentage using conditional formatting, progress to the nearest day. It is not clear where you would want to show hours in a day in increments of 15 mins.

    Please provide a copy of your that shows what kind of results you want to get. Just mock up the values, we will help with formulas.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. gantt chart in hours vs days etc
    By jackshield in forum Excel General
    Replies: 6
    Last Post: 09-14-2023, 01:33 PM
  2. Gantt chart - need to track multiple dates
    By MatthewC83 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-01-2021, 06:46 AM
  3. Gantt chart by date and hours in a day help please
    By maidenc in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-24-2021, 06:47 AM
  4. [SOLVED] Number of hours between specific times Monday to Friday with exclusions- Timesheet
    By cj0044 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-16-2019, 06:27 PM
  5. Calculate hours worked between fixed dates on Monday through Friday.. [Newbie]
    By Richard Bakker in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2019, 11:09 AM
  6. Creating a date based Gantt chart to track stock levels
    By freshchai in forum Excel General
    Replies: 1
    Last Post: 05-19-2017, 12:03 AM
  7. [SOLVED] Help change Friday to following Monday
    By David in forum Excel General
    Replies: 4
    Last Post: 06-21-2006, 08:30 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