+ Reply to Thread
Results 1 to 3 of 3

Help needed with Gantt project excel sheet with half days included

  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    Daventry, England
    MS-Off Ver
    2016
    Posts
    2

    Red face Help needed with Gantt project excel sheet with half days included

    Hi All

    I am pretty limited with use on excel, so need some help. I am using the Gantt template from Excel 2016 and trying to amend to use it for a workshop planner but with half days included. So a job may start in the PM of day 18 and finish in the AM of day 26.

    How can I do this so the filled cells pick up half days as well?


    Workshop planner.png


    Many Thanks

  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,728

    Re: Help needed with Gantt project excel sheet with half days included

    We can't do much with a PICTURE of an Excel sheet - why don't you attach the file itself, and point out exactly what you want to achieve?

    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 does not work.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    05-18-2017
    Location
    Daventry, England
    MS-Off Ver
    2016
    Posts
    2

    Re: Help needed with Gantt project excel sheet with half days included

    Thanks Pete_UK

    Think I've done it right???
    Attached Files Attached Files

+ 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] Days Remaining in Contruction Gantt Sheet
    By RubenExcel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-15-2016, 06:27 PM
  2. Recreate Gantt Chart logic used in Microsoft Project in EXCEL
    By skyline255 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2013, 12:54 AM
  3. How do I count the number of people needed on a project over various days?
    By seppopovich in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 09:22 AM
  4. Excel Marquee! Workbook included with half-working example
    By spursrule68 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2012, 02:42 PM
  5. Project Plan Creation in Excel (Gantt Charts)
    By leeb1977 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2008, 05:58 AM
  6. Excel Sick Days / Half Days
    By Pixie_1 in forum Excel General
    Replies: 6
    Last Post: 02-28-2007, 08:28 AM
  7. Replies: 2
    Last Post: 11-19-2005, 12:10 AM

Tags for this Thread

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