Results 1 to 3 of 3

Thread: Remove Time from Start/Finish Date Columns When Exporting to Excel

  1. #1
    Join Date
    Sep 2005
    Posts
    95

    Remove Time from Start/Finish Date Columns When Exporting to Excel

    One of my clients, whom I need to send the Project file every week, complaints me that he get the Time as well in the start/finish dates column when he converts the same in excel. Let me tell you that all I need to know is the Dates hence I never deal with time. I don’t know how he gets the time as well which he needs to remove manually every week.

    So I wanted to know if there is any way we can remove this “Time” option permanently so only dates appear in those columns? After doing some research on Project plans I found an option to specify the working time but It appears like needs to be in both fields and hence it was not allowing me to delete these fields.

    Any help would be appreciated.

  2. #2
    Join Date
    Dec 2006
    Posts
    489

    Re: Remove Time from Start/Finish Date Columns When Exporting toExcel

    Nope, I don’t think changing the display from Tools > Options > View tab will allow you to only show date and not time because though you are not dealing with Time (as you said above) but Project deals with it hence the time data will also be exported to project. The only way you can help your client is tell him to change the cell formats once the data is converted into Excel. This may help you both.

  3. #3
    Join Date
    Sep 2004
    Posts
    142

    RE: Remove Time from Start/Finish Date Columns When Exporting to Excel

    It is probably easiest to do this in Excel. Highlight the entire row or column. Right click and select "Format Cells" Select a date format without hh:mm. See if it works for you.

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, 12:15 AM
  2. Replies: 1
    Last Post: 12-02-2010, 02:02 PM
  3. MS Project 2003 Start/Finish Date Issue
    By mehunter48 in forum Windows Software
    Replies: 0
    Last Post: 14-09-2009, 08:35 PM
  4. Project 2007: Actual Finish Date & Finish
    By Tahseen Shahzad in forum Microsoft Project
    Replies: 3
    Last Post: 08-10-2008, 04:53 PM
  5. Changing start date and creating formula for finish date
    By stringse in forum Microsoft Project
    Replies: 1
    Last Post: 11-09-2006, 01:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •