Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-04-2010
Member
 
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.

Reply With Quote
  #2  
Old 15-04-2010
Member
 
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.
Reply With Quote
  #3  
Old 15-04-2010
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Remove Time from Start/Finish Date Columns When Exporting to Excel"
Thread Thread Starter Forum Replies Last Post
Can I establish start and finish time for specific task? Soumen Microsoft Project 5 04-02-2011 12:15 AM
How to remove/ignore the 'time' from the start/finish columns Mannie Windows Software 1 12-02-2010 02:02 PM
MS Project 2003 Start/Finish Date Issue mehunter48 Windows Software 0 14-09-2009 08:35 PM
Project 2007: Actual Finish Date & Finish Tahseen Shahzad Microsoft Project 3 08-10-2008 04:53 PM
Changing start date and creating formula for finish date stringse Microsoft Project 1 11-09-2006 01:13 PM


All times are GMT +5.5. The time now is 07:22 PM.