Calculated field

A
assaf f 👤 Member for 18 years 5 months
B
Bo Johnsen 👤 Member for 20 years 3 months

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

M
Mike Testro 👤 Member for 20 years 5 months

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

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