Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 Update Start & Finish Date Time problem

In the Open Standard
Yalçın GünerMember for 11 years 5 months
Created
5
3
0

Hi All,

 

I have a problem about update my schedule. When I imported my actual dates from excel to primavera, I see my actual start & finish column shows 00:00 time format Even though my works time starts 08:00 and finish 16:00. This couses unexpected variance.

For Example Although my baseline start & Finish 10-oct-16 08:00 , 14-oct-16 16:00 my imported actual dates shows 10-oct-16 00:00 , 14-oct-16 00:00 and this couses "variance- bl1 finish date" column show "1d" variance

 

I want to find a way to fix this automaticly like global change or format change. I tried approximately 3-4 hours on it and I didn't get any result.

 

Plesae share me any idea of you about this.

Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    why did you not fix the time

    why did you not fix the time correctly BEFORE you imported it. So export the activities to excel where the status is not equal to not started. This will give you actual and inprogress activities make sure to include the actual start and finish columns. Now in the actual start column highlight that column and select find and replace. Now in the find portion type in the incorrect time 00:00 and in the replace portion type in 8:00 then select replace all. Now do the same for the data in the actual finish column find and replace and in the find portion type in the incorrect time 00:00 and in the replace portion type in 16:00 then select replace all.

    save the file import back into p6 

    also turn on your duration decimals and make sure that you do not have any fractions of days only whole days. Also check any constraints ALL start constraints should start at 8:00 AM and all finish constraints should finish at 16:00 PM.

    Also check the project must finish by date the TIME should be 16:00 

    Also check the data date time this should be 8:00 AM
     

    Report
  2. 0
    Yalçın Güner ·
    #2

    Thank you zolan. I have found

    Thank you zolan. I have found another way to fix this before import dates.

    Report
  3. 0
    Zoltan Palffy ·
    #3

    do tell what you did

    do tell what you did 

    Report
  4. 0
    Yalçın Güner ·
    #4

    I have changed my date's

    I have changed my date's format in excel before import to primavera. First I have to convert my date to Text via apostrophe('). Then I have used columns that 8:00:00 AM for start and 4:00:00 PM for finish. Then I have linked up date field and time field via CONCENTENATE command. 

    For example Date(20-oct-2016) which in a cell and Time(_8:00:00 AM) in b cell in excel

    'a&b= '20-oct-2016 8:00:00 AM 

    Then our dates get ready to import correctly.

     

    Not : I have used visual basic editor to add apostrophe in each cell because of format problem that our date's format changes from date to custom like that 426663 8:00:00 AM.

    Report
  5. 0
    Zoltan Palffy ·
    #5

    yes that is what I do also

    yes that is what I do also you have to put the apostrophe (') in there and I also use the  CONCENTENATE command but you can use the & to combine 2 cells together instead of using Concentenate. 

    But you got the jist of how to do it now

    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?