Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calendar duration

Status
Not open for further replies.

bestchild

IS-IT--Management
Mar 20, 2007
16
CN
Hi,

I would like to know if there is any duration field can include holidays or non-working days ?

Thanks.
 
In the duration field, enter the time as "10 edays" for 10 elapsed days.
 
Thanks.

Sorry for my blur question.
I want to enter and estimate the duration by normal working days. But I want to know how long it is including non-working days.

for example :
in 5 Day work calendar (Mon-Fri)
entered duration : 3 days

If the start day is on Mon, so it will be Mon to Wed, the information I need should be 3 Days.
If the reschedule the start day to be on Fri, so it will be Fri to Tue, the information I need should be 5 days.

is it possible ?
Thanks.
 
Use this formula in Duration1

(datediff("d",[Start],[Finish])+1)*[Minutes Per Day]

 
Thanks.

I failed paste the formula on the duration1.
but i will learn myself.
Don't show me until I ask :p

haha

Thanks !!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top