dates format when exported to excel
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Rouzbeh,
Once you assigned time to activity it still can adjust to 12:00Am but you schedule would have wrong output therefore yes you have to live with it.
I’m also using MS Office 2003 and replace function is working fine. You better check the default font as it has different equivalent on key stroke.
Rodel,
If the activity calendar is for example 8:00 AM to 5:00 PM then time can not be set to 12:00 AM, can it.
So I guess I have to live with it. Is that correct.
Moreover, normally when exported to excel, I used VALUE formula to change the text format to date. I tried to use ctr+h and replace with blank, but excel 2003 seems does not recognizes this character and says couldnt find any to replace.
Regards,
Rouzbeh
Roozbeh,
Edit-> Users Preferences-> Date tab-> Time-> 12 hour format and select show minute. Then you can change time for all dates.
Rodel,
where in P6 we can change time to 12:00 AM
regards
Roozbeh,
By default P6 use 12:00 AM time and all activities having default 12:00AM will not export time format but once you change the 12:00AM default time and assigned a regular time like 08:00 AM for start and 05:00PM for end of day then it will include time format. There is no way you can prevent exporting date format only once you assigned the correct time because thats P6 calculating base.
Rodel,
thanks for your reply. in fact this is what I do every time I export to excel.
do you have any idea why some times this happens with export to excel. in some cases i noticed that the time is not exported. especially i noticed that for a project with resource dependant activities which there were no relationship between activities and activites were scheduled based on their asignments.
in addition, is there any way to prevent that. some times when I need to do frequent exports to excel, it would save time and effort for each time changing the format in excel.
Roozbeh,
All data exported to excel is a text format. To change the format highlight all date and press Ctrl+h (replace command). Enter on find what and leave the replace with empty then click replace all. Format will change automatically to date. Highlight again and press Ctrl+1 (format cell command) and select the date format you want.