The 8 business days left is a variable based on the start date and end
date, so the 8 can't be hard coded into the calc.

Thanks

Kim 

 

From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED]
On Behalf Of Lee Smith
Sent: Wednesday, February 20, 2008 12:19 PM
To: [email protected]
Subject: Re: Need help with a calc!

 

Maybe:

 

Case (Date ( start date ; start date ; start date +1 )  =  End date; 0;
(target hours  - total hours) /8)

 

 

On Feb 20, 2008, at 11:42 AM, Kim Parris wrote:





If((Date(Month(start date), Day(start date), Year(start date) +
1)-1)=End date, 0 ,

If(target hours - total hours > 0 , (target hours -  total hours) /
((365+ If((Date(Month(start date), Day(start date), Year(start date)
+1)- start date + 1) = 366,1,0) - (End date - start date +1))*5/7),0))

 

 

Reply via email to