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))
