Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Calculated field

2 replies [Last post]
Wed, 2009-06-10 02:41
assaf f
User offline. Last seen 11 years 15 weeks ago. Offline
Joined: 26 Dec 2007
Posts: 32
Groups: None
Hi,
How can I calculate the duration between the task’s finish date and today?
Only including the working days.
I’ve tried [finish]-date() but it uses the entire week and not only working days.

Thanks,
Assaf
Top

Replies

Thu, 2009-06-11 03:55
#1
Bo Johnsen
User offline. Last seen 9 years 21 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
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
Top
Wed, 2009-06-10 05:49
#2
Mike Testro
User offline. Last seen 34 weeks 3 days ago. Offline
Joined: 14 Dec 2005
Posts: 4420
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
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
Top