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.
|