Andrea C
03-10-2011, 01:53 PM
Hello Everyone,
I have tried to make this work with out luck :( . Any help is greatly appreciated. Here's what I am trying to accomplish:
Create groups of when the people ended at the same time, if they are under the same type (I think I have that part correct) - The problem is that when the ended (time) is +1, 2 or 3 minutes, it is still considered the same group as long as they are the same type. I don't know how to add to this the formula (for example if C2 = C1 or C2 is greater than C1 by 1, 2 or 3 minutes, and B2=B1, then give me D1, otherwise, give me D1+1) I have attached a small sample of data.. I am dealing with 600+ rows so fixing one by one is very time consuming and I don't really know how to work with the H:MM number type.
Please le tme know if I need to clarify this a bit more. Thank you for any help in advance, it is greatly appreciated.
Regards,
Andrea.
I have tried to make this work with out luck :( . Any help is greatly appreciated. Here's what I am trying to accomplish:
Create groups of when the people ended at the same time, if they are under the same type (I think I have that part correct) - The problem is that when the ended (time) is +1, 2 or 3 minutes, it is still considered the same group as long as they are the same type. I don't know how to add to this the formula (for example if C2 = C1 or C2 is greater than C1 by 1, 2 or 3 minutes, and B2=B1, then give me D1, otherwise, give me D1+1) I have attached a small sample of data.. I am dealing with 600+ rows so fixing one by one is very time consuming and I don't really know how to work with the H:MM number type.
Please le tme know if I need to clarify this a bit more. Thank you for any help in advance, it is greatly appreciated.
Regards,
Andrea.