Results 1 to 2 of 2

Thread: How to remove/ignore the 'time' from the start/finish columns

  1. #1
    Join Date
    Feb 2010
    Posts
    1

    How to remove/ignore the 'time' from the start/finish columns

    I have created a column with red and green indicators that display following this formula - [Finish]<=[Baseline Finish]
    Yes = green
    No = red

    So if the Finish date has slipped and occurs after Baseline Finish, the column will show a Red circle against that task, otherwise it is green.

    It works ok apart from the instance when the only difference in the finishing dates are the actual times of completion, on the same day. Sometimes Project will be showing a task finishing at 12pm and the baseline finishes at 5pm, so it will mark that task as RED.

    But this programme is not being micromanaged to the level of hours, just days, so I would like to know how to write a formula that is based on - [Finish]<=[Baseline Finish] - but ignores the time differences, OR a way of not including the 'time' in the start/finish fields.

    Can this be done?? Many thanks if you can provide a solution!!

  2. #2
    Join Date
    Nov 2008
    Posts
    1,259

    Re: How to remove/ignore the 'time' from the start/finish columns

    Reformat the formula of Finish like this one -

    Format(Finish,"ddd mm/dd/yy ")
    and Baseline Finish as
    Format(Baseline Finish,"ddd mm/dd/yy ")

Similar Threads

  1. Can I establish start and finish time for specific task?
    By Soumen in forum Microsoft Project
    Replies: 5
    Last Post: 04-02-2011, 01:15 AM
  2. Replies: 2
    Last Post: 15-04-2010, 02:57 AM
  3. Changing Start & Finish Dates
    By akbar in forum Microsoft Project
    Replies: 3
    Last Post: 14-04-2010, 11:33 PM
  4. Replies: 3
    Last Post: 12-08-2009, 07:11 PM
  5. Task Start & Finish dates
    By Antonio00 in forum Microsoft Project
    Replies: 6
    Last Post: 17-03-2009, 09:48 PM

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
  •  
Page generated in 1,713,522,018.59339 seconds with 17 queries