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
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Tue, 2010-06-15 09:10
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.
Member for
22 years 5 months
Member for22 years5 months
Submitted by Roozbeh Taheri on Sat, 2010-06-12 12:35
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.
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Sat, 2010-06-12 10:58
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.
Member for
19 yearsRE: dates format when exported to excel
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.
Member for
22 years 5 monthsRE: dates format when exported to excel
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
Member for
19 yearsRE: dates format when exported to excel
Roozbeh,
Edit-> Users Preferences-> Date tab-> Time-> 12 hour format and select show minute. Then you can change time for all dates.
Member for
22 years 5 monthsRE: dates format when exported to excel
Rodel,
where in P6 we can change time to 12:00 AM
regards
Member for
19 yearsRE: dates format when exported to excel
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.
Member for
22 years 5 monthsRE: dates format when exported to excel
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.
Member for
19 yearsRE: dates format when exported to 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.