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