Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
durations
microsoft office professional 2003
i have a project schedule consisting of serveral tasks with different durations for each task. i need to format one cell to show a start and finsish date for each task and a final cell showing the total duration for all tasks. task 1 task 2 task 3 total duraction 5/29-6/2 6/3-6/10 6/11-6/12 ????? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
durations
Use two date cells for each task: a start date and a finish date. DO NOT put 5/29-6/2 into one
cell. Then simply subtract the starting cell from the ending cell, and add 1 to get the duration in days. HTH, Bernie MS Excel MVP "chad" wrote in message ... microsoft office professional 2003 i have a project schedule consisting of serveral tasks with different durations for each task. i need to format one cell to show a start and finsish date for each task and a final cell showing the total duration for all tasks. task 1 task 2 task 3 total duraction 5/29-6/2 6/3-6/10 6/11-6/12 ????? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
durations
First install this tiny UDF:
Function duration(s As String) As Integer t = Split(s, "-") duration = DateValue(t(1)) - DateValue(t(0)) End Function Then, with your data in A1 thru C1, in D1 enter: =duration(A1)+duration(B1)+duration(C1) to see 12 -- Gary''s Student - gsnu200725 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
durations
seems i can't see the forest for the trees again. your advice worked.
however, another issue has come up. after i formatted all of my cells to calculate the duration of a particular task the number 1 shows up in that cell if no start and end dates have been entered yet. this schedule will be constanly updated and changing so i won't always have my dates in place from the begining but i would like to have my "running total" duration current. with that said my total will not be accurate since 1 will be added at each task not yet assigned a start and a stop date. thanks "Bernie Deitrick" wrote: Use two date cells for each task: a start date and a finish date. DO NOT put 5/29-6/2 into one cell. Then simply subtract the starting cell from the ending cell, and add 1 to get the duration in days. HTH, Bernie MS Excel MVP "chad" wrote in message ... microsoft office professional 2003 i have a project schedule consisting of serveral tasks with different durations for each task. i need to format one cell to show a start and finsish date for each task and a final cell showing the total duration for all tasks. task 1 task 2 task 3 total duraction 5/29-6/2 6/3-6/10 6/11-6/12 ????? thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
durations
Chad,
Use a formula like =IF(A2="","",B2-A2+1) HTH, Bernie MS Excel MVP "chad" wrote in message ... seems i can't see the forest for the trees again. your advice worked. however, another issue has come up. after i formatted all of my cells to calculate the duration of a particular task the number 1 shows up in that cell if no start and end dates have been entered yet. this schedule will be constanly updated and changing so i won't always have my dates in place from the begining but i would like to have my "running total" duration current. with that said my total will not be accurate since 1 will be added at each task not yet assigned a start and a stop date. thanks "Bernie Deitrick" wrote: Use two date cells for each task: a start date and a finish date. DO NOT put 5/29-6/2 into one cell. Then simply subtract the starting cell from the ending cell, and add 1 to get the duration in days. HTH, Bernie MS Excel MVP "chad" wrote in message ... microsoft office professional 2003 i have a project schedule consisting of serveral tasks with different durations for each task. i need to format one cell to show a start and finsish date for each task and a final cell showing the total duration for all tasks. task 1 task 2 task 3 total duraction 5/29-6/2 6/3-6/10 6/11-6/12 ????? thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
durations
it worked great.
thanks "Bernie Deitrick" wrote: Chad, Use a formula like =IF(A2="","",B2-A2+1) HTH, Bernie MS Excel MVP "chad" wrote in message ... seems i can't see the forest for the trees again. your advice worked. however, another issue has come up. after i formatted all of my cells to calculate the duration of a particular task the number 1 shows up in that cell if no start and end dates have been entered yet. this schedule will be constanly updated and changing so i won't always have my dates in place from the begining but i would like to have my "running total" duration current. with that said my total will not be accurate since 1 will be added at each task not yet assigned a start and a stop date. thanks "Bernie Deitrick" wrote: Use two date cells for each task: a start date and a finish date. DO NOT put 5/29-6/2 into one cell. Then simply subtract the starting cell from the ending cell, and add 1 to get the duration in days. HTH, Bernie MS Excel MVP "chad" wrote in message ... microsoft office professional 2003 i have a project schedule consisting of serveral tasks with different durations for each task. i need to format one cell to show a start and finsish date for each task and a final cell showing the total duration for all tasks. task 1 task 2 task 3 total duraction 5/29-6/2 6/3-6/10 6/11-6/12 ????? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up time durations? | Excel Discussion (Misc queries) | |||
Adding durations | New Users to Excel | |||
Pivot table: sum of durations | Excel Worksheet Functions | |||
distribution of durations | Excel Worksheet Functions |