Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

We know that dates are often off by 1 day because there are hidden decimals - but main source & main fix?

3 replies [Last post]
John Reeves
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 10 May 2013
Posts: 342
Groups: None

We know that dates are often off by 1 day because there are hidden decimals - but main source & main fix?

Replies

Zoltan Palffy
User offline. Last seen 3 weeks 1 day ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

there are 2 things that do this 

#1 as you mentioned the Original durations and or remaining durations are not whole numbers.

soultion is to always make the remaining durations whole numbers.

#2 the TIMES are incorrect could be the project start time 

Actual starts and or finish TIMES

Constraint date TIMES

the data date TIME

typically all start TIMES should be 8:00 am or the earliest start time in any of your calendars

typically the finish TIMED should be 5:00 pm or the latest workig hours in all of the calendar 

This holds true for actual start, actual fininsh and constraint TIMES.

I would also eliminated the defaut 1 hours lunch time between 12:00 and 1:00

so a typical day would start at 8:00 am and finish at 4:00 pm

doing this keeps your sechedule consistant as far as dates and times are concerned. 

 

The decimal in the duration usally results whe you update the duration % complete and not updating the remaining duration  manually i.e. a 5 day activity that is 50% complete will yield a remaining duration of 2.5 days but without the decimal places turned on will show a whole number of 3 days remaining.

 

 

 

 

Santosh Bhat
User offline. Last seen 1 year 1 week ago. Offline
Joined: 15 Apr 2005
Posts: 381

John, I wrote a post about it on LinkedIn on how to find these:

P6 Schedules - Activity Date / Time Issues | LinkedIn

 

8161
P6 Schedules - Activity Date / Time Issues

The decimals are usually down to people entering durations to match dates, or from imports from excel, where the duration has been developed form a formula that might be from a prodcution rate etc.

The part-days is usally due to the status or activity constraint timestime being set to 00:00 instead of 08:00 or whenever the calendar start time is.

Rodel Marasigan
User offline. Last seen 33 min 31 sec ago. Offline
Joined: 25 Oct 2006
Posts: 1699

Just show the decimal so you know the reason why? Usually it happen when using multiple calendar with different end working hours or when updating and not paying attention on the hour when ticking started and or finished tick boxes on Status.