Calculated field

A
assaf f 👤 Member for 18 years 7 months
B
Bo Johnsen 👤 Member for 20 years 5 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 7 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

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts