That will do the trick if the working days are to be calculated with respect to your standard calendar (with weekends, holidays, etc. defined) and based on a 8 hour working day. The division by 480 (60min/hr x 8hrs/day)is to get the result from minutes to days. If working e.g. 9 hrs a day the number should be 540 (9x60).
Member for
19 years 8 monthsRE: Calculated field
Hi Assaf,
You just need to change your formula a bit:
ProjDateDiff(Date(),[Finish],"Standard")/480
That will do the trick if the working days are to be calculated with respect to your standard calendar (with weekends, holidays, etc. defined) and based on a 8 hour working day. The division by 480 (60min/hr x 8hrs/day)is to get the result from minutes to days. If working e.g. 9 hrs a day the number should be 540 (9x60).
Regards,
Bo
Member for
19 years 10 monthsRE: Calculated field
Hi Assaf
In Lotus 123 there is a formula that counts the number of work days between two calendar dates @networkdays(date 1, date 2,Holiday-range,"weekend")
You need a range of dates that represent the holidays between date 1 & 2 and the numbers "56" to represent UK Sat & Sun weekends.
Israel mey have different day numbers.
There is a similar formula in excell but I don’t think it works so elegantly as Lotus.
Best Regards
Mike Testro