#1
|
|||
|
|||
Summing Durations between 2 locations?
Hello, I am working on trying to sum the durations for each "area" separately. There is much more data and it is ever-changing. I'm having a problem and was wondering if any of you kind folks might have a suggestion.
One individual gave me a formula that will sum up all trips to "2nd Street" separately, but is there a way to sum up only the durations leaving from "1st Street" and arriving at "2nd Street" separately? Example: Column A...........................Column B 1st Street............................Leave .........................................0:00:29 .........................................0:00:04 .........................................0:03:43 2nd Street............................Arrive 2nd Street............................Leave .........................................0:02:18 .........................................0:00:17 .........................................0:00:54 4th Street............................Arrive 1st Street............................Leave .........................................0:04:46 .........................................0:01:17 2nd Street............................Arrive 2nd Street............................Leave .........................................0:00:19 .........................................0:00:52 1st Street............................Arrive Again, the goal here is to sum each trip separately from "1st Street" to "2nd Street". Thanks again in advance. |
#2
|
|||
|
|||
Another user was able to give me an answer to my dilemma so I probably won't attach a file, but i will provide a bit of an explanation as to what my problem was and the formula provided to me to help correct it in case it may sometime help another.
In my example above I had a formula that would sum all of the "Leave" to "Arrive" times seperately and display them in column C. This was great and to take it one step further I was looking to sum, in column D, the separate durations of only the "1st Street" to "2nd Street". The formula to sum specific trips (Street 1 to 2,3 to 1, etc) seperately from "Leave" to "arrive",assuming the data starts in A3, is as follows: =IF(AND(B2="2nd Street", C2="Arrive", INDEX($A$1:$A1,MATCH("z*",$B$1:$B1,1))="1st Street"), SUM(INDEX($B$1:$B1, MATCH("z*", $B$1:$B1, 1)):$B1), "") Thanks again for the help and hopefully someone else can benefit from this as well. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Durations | rowan.bradley | Project | 1 | 12-15-2015 05:34 PM |
Challenge summing time (mm:ss) values? | Mr Davo | Excel | 3 | 12-17-2014 10:41 AM |
New Cost columns are not summing up. | elvanaguven | Project | 3 | 11-08-2014 02:28 PM |
Why does not summing up from different sheet work? | Kh1978 | Excel | 1 | 05-14-2014 02:22 AM |
SUMMING TWO COLUMNS | LOGISTICS1 | Excel | 1 | 04-18-2006 06:00 AM |