Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using date format in the cells how determine percent complete
I have 8 steps to a particular activity. I need to show the dates each step
is completed but I also need to determine the percent complete of the overall activity. Any suggestions would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using date format in the cells how determine percent complete
If the overall start and finish dates are in A2 and I2, then if you have,
for example the 4th step, which runs from E2 to F2, the percentage of the total is =(F2-E2)/(I2-A2) formatted as a percentage. -- David Biddulph "boiseman62" wrote in message ... I have 8 steps to a particular activity. I need to show the dates each step is completed but I also need to determine the percent complete of the overall activity. Any suggestions would be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using date format in the cells how determine percent complete
hi
not sure what you are asking but... percent is calculated as a portion compared to the total. 8 steps in the total so each step would be 12.5%. if your are trying to calculate the percent based on date then you would have to know the end date to calculate a percent. end date - start date = total time. then the start date would have to be subtracted from each ste[ end date and then devided by the total time. so unless you have the future end date (or a reasonable estimate), it would be difficult to calculate a percent based on date. regards FSt1 "boiseman62" wrote: I have 8 steps to a particular activity. I need to show the dates each step is completed but I also need to determine the percent complete of the overall activity. Any suggestions would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula percent complete excluding given text string | Excel Discussion (Misc queries) | |||
Format Cells to calculate hours and minutes taken to complete task | Excel Worksheet Functions | |||
Track progress to lookup percent complete on another worksheet. | Excel Worksheet Functions | |||
Percent Complete? | Excel Discussion (Misc queries) | |||
Percent Complete? | Excel Discussion (Misc queries) |