Creating Custom Date Field using working days

Question

I would like to take a custom date field and add 16.5 hours to my start date/time.  I am using the following formula:  ProjDateAdd([Start],"+16.5h").  This is working EXCEPT my return is associated with my holiday calendar and I would like that number to be associated with no calendar.  If I have an activity starting on Friday 02/06/15 at 0800 I would like the return date in the custom date column to be 02/07/15 at 1830.

Is there any way to do this.

I am using Project Professional 2010 on an EPM Server.

Respectfully

PClem

Answer 1

Please help, my Microsoft Office 2010 I got in 2010, is know having problems.  

I have use Excel and Access for about 5 years for my home, but about 3 weeks ago, it said I have retired and it quit working.

But I had bought office 2010 for my home, but it said I was retired,  so it always stops when I start a program.  But yesterday, I re installed the Microsoft Office 2010 and enter the 2010, 25 numbers to get it to install, and it world good. but at almost 12 pm it started stop again.

Now it says...  "Microsoft Setup Bootstrapper has stopped working"

I have tried to uninstall my 2010 version, but went it first stop me, I was 3 programs installed on 2/12/2015,

and it would not let me uninstall any of them

I have been helping folks for free, but now I can't use Excel or Access to help them.

Please help me, maybe you can check my pc over the internet or tell me how to fix things.

Harrell Geron

******@gmail.com

Or   ******@hotmail.com   that I used for about 15 years for Windows.  It is automatically forward to ragknot on Google, but I can use the older version use the Internet, not Google.  I think I used harrellgeron@hotmail,com when I bought the Microsoft Office 2010.

Answer 2

PClem,

I have a question. How do you get from Friday at 0800 to Saturday at 1830 with 16.5 hours? Using a 24 hour calendar, the finish time would be Saturday at 0030. Using a normal 8 hour work day, the finish time would be Saturday at 0430 (no lunch break) or 0530 with a l hour lunch break. If the work day is 7 hours with a 1 hour lunch break, then the finish time should be Sunday 1030.

What am I missing?

John

Answer 3

Hi,

Quite simple.

Use the Dateadd function instead of ProjDateAdd

Greetings,

Answer 4

Thank you for the feedback.

I actually went and dug up something I finally found that I was given several years ago and it worked amazingly enough.  I used: IIf([Start]<cdate("3/29/15") And [Start]<cdate("3/28/16"),Datevalue([Start])+Timevalue([Start])+Timevalue("16:30:00"),datevalue([Start])+timevalue([Start])+timevalue("16:30:00"))

This was originally set up to take into consideration daylight savings time (below) however, I didn't need the DST but I wasn't sure what to do to get rid of so I improvised as above and I believe it work.

My formula originally was

IIf([Start]<cdate("3/29/15") Or [Start]>=cdate("10/25/15") And [Start]<cdate("3/28/16"),Datevalue([Start])+Timevalue([Start])+Timevalue("16:30:00"),datevalue([Start])+timevalue([Start])+timevalue("14:30:00"))

Answer 5

PClem5154 --

According to the Help article on the ProjDateAdd function, "For Project Server, the Standard calendar will be used, regardless of which calendar is specified in the calendar string."  So, your formula is going to use the enterprise Standard calendar no matter what you do.  Sorry.  Hope this helps.