Thanks Santosh, Typical NTP contract interpretation is using Finish Milestone and not Start Milestone that is why the Contract defines NTP + ? days = completion date. That's why I am confused on the formula being used. Also if the data is coming from P6 using copy paste or export (it depends on the setting and layout of the user) whether the time is shown or not otherwise the data is always whole number format or 12:00AM therefore in excel it always count as 1 day and not a fraction of a day.
Member for
20 years 6 months
Member for20 years6 months
Submitted by Santosh Bhat on Fri, 2022-01-07 07:12
Rodel, It does depend on the nature of the task being assessed. Generally, a one day task in scheduling will be the same date, consider a task starting 1-Jan at 08:00 and of duration one day. The date will still be 1-Jan, but the time will be 17:00.
In Excel, a value of 1 is calculated as a whole 24hr Day. so to check how calcs are being performed in Excel, you will need to display the number format to include hh:mm
John, a few I use:
edate - calculate the same date a number of months plus or minus
yearfrac - caluclate the % of a year between two dastes
datedif - calculate the difference between two dates in various methods, days, months etc.
eomonth - calculate the end of the month (or multiple months) from a certain date
Weekday - returns the day of the week from 1-7 of a date (useful if you need to know if its a weekend or not
Excel is good for dates, just make sure you view the time also as scheduling tools may export the date & time as a fraction of a day, and this can through Excel calcs out.
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Fri, 2022-01-07 03:25
Not sure how are you interpreting the formula and your understanding of NTP + ?days (completion date). To make it simple lets say NTP + 1 day = completion date. Say NTP = 1 Jan 2022 + 1 day = 2 Jan 2022. If I used your formula, @sum((NTP + 1 day) - 1), the completion date will be still 1st Jan 2022? which make no sense.
Member for
16 years 3 monthsone way in excel is to make
one way in excel is to make the NTP date 1 days less than what it is in p6 and all dates wil then work out to match p6
so all you need to do is adjust the starting date which is NTP
Member for
21 years 8 monthsUse date-hour format for
Use date-hour format for granularity.
Try Date Formulas showing date-hours
Member for
19 yearsThanks Santosh, Typical NTP
Thanks Santosh, Typical NTP contract interpretation is using Finish Milestone and not Start Milestone that is why the Contract defines NTP + ? days = completion date. That's why I am confused on the formula being used. Also if the data is coming from P6 using copy paste or export (it depends on the setting and layout of the user) whether the time is shown or not otherwise the data is always whole number format or 12:00AM therefore in excel it always count as 1 day and not a fraction of a day.
Member for
20 years 6 monthsRodel, It does depend on the
Rodel, It does depend on the nature of the task being assessed. Generally, a one day task in scheduling will be the same date, consider a task starting 1-Jan at 08:00 and of duration one day. The date will still be 1-Jan, but the time will be 17:00.
In Excel, a value of 1 is calculated as a whole 24hr Day. so to check how calcs are being performed in Excel, you will need to display the number format to include hh:mm
John, a few I use:
Excel is good for dates, just make sure you view the time also as scheduling tools may export the date & time as a fraction of a day, and this can through Excel calcs out.
Member for
19 yearsNot sure how are you
Not sure how are you interpreting the formula and your understanding of NTP + ?days (completion date). To make it simple lets say NTP + 1 day = completion date. Say NTP = 1 Jan 2022 + 1 day = 2 Jan 2022. If I used your formula, @sum((NTP + 1 day) - 1), the completion date will be still 1st Jan 2022? which make no sense.