View Single Post
 
Old 03-06-2016, 03:41 PM
Avsfan3319 Avsfan3319 is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2016
Posts: 2
Avsfan3319 is on a distinguished road
Default 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.
Reply With Quote