Prev: Current Date
Next: Problem with copying and pasting tasks and keeping predecessors in
From: JulieS on 14 Apr 2010 17:16
Hello Colleen,

Sorry, no. Even if you change the display (Tools > Options, View
tab) to only show date and not time, the time data will be
exported to project. Even though *you* are not dealing with
time, MS Project is.

The best I can suggest is just to change the cell formats once
the data is in Excel.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

On 4/14/2010 5:00 PM, Colleen wrote:
> One of my managers says that when I send her the MSProject file and she
> converts it to Excel that in addition to the start/finish dates, it puts in a
> time in that field as well. For our project we are not dealing with time at
> all, so all we need to know is the dates. She's been manually removing this
> time from the field each week, but we are wondering if there is a way to
> remove this time option so only dates appear in those columns? I look in the
> project plan options and found an area to specify the working times, but when
> I tried to delete both fields it would not allow me. It seems that a time
> needs to be in both fields. Please confirm if there is a way to remove this
> time stamp from the start/end date columns. Thanks!
>
> Colleen
 | 
Pages: 1
Prev: Current Date
Next: Problem with copying and pasting tasks and keeping predecessors in