I'm an excel dummy, so please bear with me!
I'm creating a worksheet that tracks how long a certain project takes to get completed. The sheet, too, needs to calculate how long the project spent in different locations.
Ie:
I have an initial start time, go to stop two, three, four, etc.
At each of the stops, I've set up an "elapsed time" field to calculate the time it took to get from one to two and then from two to three, etc. At the end of all stops, I need a formula to calculate total duration.
I've run into a problem, though. Some projects may need to go two stops before they are completed while other projects might need to go to three, or four, etc. How do I make the formula know that if one of the duration times is blank, that that particular project is completed? How do i let the final total field know that as well?
(ie for some projects it will need to add stops 1-7 while other projects it only needs to add from maybe 1-2?
Thanks!
Dawn
I'm creating a worksheet that tracks how long a certain project takes to get completed. The sheet, too, needs to calculate how long the project spent in different locations.
Ie:
I have an initial start time, go to stop two, three, four, etc.
At each of the stops, I've set up an "elapsed time" field to calculate the time it took to get from one to two and then from two to three, etc. At the end of all stops, I need a formula to calculate total duration.
I've run into a problem, though. Some projects may need to go two stops before they are completed while other projects might need to go to three, or four, etc. How do I make the formula know that if one of the duration times is blank, that that particular project is completed? How do i let the final total field know that as well?
(ie for some projects it will need to add stops 1-7 while other projects it only needs to add from maybe 1-2?
Thanks!
Dawn