Importing excel dates- changing the 00:00 to 17:00
- Created
- 4
- 3
Importing excel dates- changing the 00:00 to 17:00 . The odd thing is when you look at the excel "bar" it shows 5/16/2018 12:00:00. I have had schedule effected by the "hours" so i want it 5pm or 17:00. I tried replace but there was no excel option with the date and time and am/pm. I am not a big fan of the way P6 "always secretly includes hours", seems like P3 was easier. I was watching a planacademy video about it and sometimes he changed the time and sometimes he did not - strange. I have given up changing it automatically with replace all in excel, maybe I will have to change all in P6 - we will see.
4 replies
Oldest first- 0Zoltan Palffy ·
couple of things1st the data
couple of things
1st the data date should be 8:00 am or the earliest times of any of your calendars.
2nd you can do a simple find and replace in excel find 12:00:00 AM and replace with 5:00:00 PM
the option is use the concatintion in excel lets say the cell in excel you need to change is cell F2 and lets say that cell H2 had the date ONLY now in cell I2 time in ' 5:00:00 PM now in cell J2 put in H2&I2
now copy this formula downs and then copy column J and pastes special VALUES for column J
3rd if you are trying to CHANGE TIMES when importing then for completed activities ONLY import the finish date and time first because if you have a 1 day activity and the start and finish dates are the same you can NOT make the start date TIME later than the finish date TIME so you have to change the finish date TIME FIRST then change the start date TIME.
this will be a 2 step process.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?