Excel 2007 : Adding Dependent on Category

**sanka** · 05-09-2009, 02:45 AM

I wish to add cells depending on adjacent cells. The columns in my sheet are Code1, Start_Time1, End_Time1, Code2, Start_Time 2, End_Time2,...,Coden, Start_Timen, End_Timen
The Code is a number between 1 and 5 and I want to add columns for time between start and end for each code.

**DonkeyOte** · 05-09-2009, 03:16 AM

I'm not quite sure I follow / visualise what you're trying to do - could you post a small sample file with dummy data & expected results ?

**sanka** · 05-09-2009, 05:08 AM

D1 Type, D2 Type are codes for delays, 1,2,3,4...,n. Type 1 Count etc are the number of delays at that node of type 1. Type 1 Duration is the part I am having a problem with. At each node point I want to add all Type Durations. There may be no delays and they are not recorded in any particular order. There may also be numerous occasion of delay type per node.