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.
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.
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.