Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to calculate duration in days

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 26-09-2008
Member
 
Join Date: Aug 2006
Posts: 115
How to calculate duration in days

I have recently created 2 new custom fields, that is, a date field (date1) and duration (duration1). I just want to calculate the difference in days between 'start' and dat1 in day. When I am trying to create a formula for duration1 of: start - date1 then I am getting an odd answer. Is there anyone who can give me some kind of a formula to calculate duration between 2 dates? Thanks.

Reply With Quote
  #2  
Old 26-09-2008
Member
 
Join Date: Oct 2005
Posts: 1,199
Re: How to calculate duration in days

Incase you want the difference in calendar days, then you can simply use the DateDiff function and if you want the difference in Working Days, then you can use ProjDateDiff function. Hope this helps.
Reply With Quote
  #3  
Old 26-09-2008
Member
 
Join Date: Aug 2006
Posts: 115
Re: How to calculate duration in days

Thank you, I tried to use the ProjDateDiff function but if I have got a different calendar than the project calendar then how can I make the distinction in the formula?
Reply With Quote
  #4  
Old 26-09-2008
Member
 
Join Date: Oct 2005
Posts: 1,199
You just need to put the name of the calendar between double quotes, like for example:
ProjDateDiff([Start],[Finish],"Six Days")

Hope this helps.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to calculate duration in days"
Thread Thread Starter Forum Replies Last Post
How to calculate pay period between interval of 15 days Bala!aditya MS Office Support 2 28-01-2012 02:43 PM
Automatically change duration from days to weeks mbbackus Microsoft Project 5 02-11-2011 02:40 AM
Calculate Working days in MySql DeMario Software Development 4 06-11-2009 05:00 PM
Duration shown in days(need) to display hours The Man Microsoft Project 0 23-09-2008 05:26 PM
duration calculation doesn't skip non-working days Donald Microsoft Project 3 24-01-2008 04:12 AM


All times are GMT +5.5. The time now is 03:18 PM.