% complete duration
I would like to calculate duration % complete from the actual start and actual end date,
Is there a formula to calculate the duration, should be calculated based on hours (24 hours)
Answers

If I'm understanding you correctly, you'd like to compare the Actual End Date value with Today's Date to determine how far along a specific task is in percent, is that correct?
If so, there currently isn't a way to do this using Hours, however you can use NETWORKDAYS to compare two dates and return how many working days are between them. For example, you can find the number of working days between the Start Date and Today's Date, then divide that by the total duration in working days:
=IF([Actual Start Date]@row > TODAY(), 0, IF([Actual End Date]@row <= TODAY(), 1, NETWORKDAYS([Actual Start Date]@row, TODAY()) / NETWORKDAYS([Actual Start Date]@row, [Actual End Date]@row)))
Note that I added two statements at the beginning, so if the task hasn't started yet it's at 0%, and if the End Date is in the past (so it's complete) then it's 100%.
Let me know if this helps and is what you're looking for!
Cheers,
Genevieve
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!