Skip to content
ProjectControls.com
Oracle Primavera - PM6

P3e to Excel date format

In the Open Standard
Minhas ShaikhMember for 19 years 6 months
Created
3
3
0
Hi Dear Planners,
In p3e, after exporting schedule in excel format. I am getting date format with time, ’8/25/2008 4:00:00 PM. How can I get rid from time and hiphen. I need to make changes in dates. Excel can’t read this date format due to time and hyphen (‘)as a date.
Thanks
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Dieter Wambach ·
    #1
    Minhas,
    very easy:
    Edit --> User Preferences --> Dates. The format you choose here will be used for the Export file-
    Regards
    Dieter
    Report
  2. 0
    Minhas Shaikh ·
    #2
    Thanks Dieter.
    I already have setpup in user preference but I am getting same result. Mean dates with time and hiphen. Also I am not getting same format which I have assigned in user preference.
    There may be another way....or somthing else....

    Minhas
    Report
  3. 0
    Dieter Wambach ·
    #3
    Sorry Minhas
    it was my mistake.
    If you just want to create reports in Excel and not import the data again: Same with the user preferences. Then:
    1. Create a report and choose, create ASCII. P3e will create a CSV-File and you can mark to open EXCEL immediately. Separator: in General ";" works the best, with some configurations ",".
    2. You create a layout with all the informations you need in the table-area --> ctrl+A to select all data --> ctrl+C --> Open EXCEL --> New file --> ctrl+V

    If you’ll want to import again - I remember I stumbled over this item some time ago - it seems that you’ll have to work with copy and paste and to modify the specific figures.

    Hope this will help!

    Dieter
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?