Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2011, 10:37 AM
OTPM OTPM is offline Using WORKDAY with fractional day lengths Windows 7 32bit Using WORKDAY with fractional day lengths Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Scaffold


Your solution is attached.
Basically Excel stores dates as the number of days since 1st January 1900. On that basis, as you have stored your individual task duration's as percentages of a day you just need to add the start date to the number of days for your first task to get the completion date of Task 1. Then for task 2 add the start date to the duration's of Task 1 and Task 2 and so on.
To obtain the end date of all the tasks simply add the start date to all the duration's of each task.
Hope this helps.
Tony(OTPM)
Attached Files
File Type: xls DateFinishCalculation.xls (14.5 KB, 29 views)
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 11:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft