r_know
09-24-2013, 11:45 AM
Dear All,
I have following column,
D E L O
00:15 4 1 Result
00:30 1 2
1:15 1 3
2:00 2 4
9:50 1 5
I want a formula in O column, if first criteria in L column 1, so find the L1=1 in the E column and do summation respective figures for time in D column.
Like for 1, 00:30+1:15+9:50= 11:35
Please can any one suggest formula?
Regards, RL>
I have following column,
D E L O
00:15 4 1 Result
00:30 1 2
1:15 1 3
2:00 2 4
9:50 1 5
I want a formula in O column, if first criteria in L column 1, so find the L1=1 in the E column and do summation respective figures for time in D column.
Like for 1, 00:30+1:15+9:50= 11:35
Please can any one suggest formula?
Regards, RL>