Calculated field
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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
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