Conditional equation based upon two variables

[dazedniteman]

Good Afternoon,

I am trying to find a way to do conditional functions based upon multiple criteria and I can't seem to find a way to do this.

What I have:
Multiple columns of information: ID, Day of Week, Week of, Start Date/Time, End Date/Time

What I would like:
I'd like to subtract the start date/times from each other IF the 'ID' and 'Week of' match each other.

A bit more detail:
the file contains a list of various IDs and the start date which is associated with each ID. Some IDs are active a few times per week whereas others are active only once per week. I'm trying to find out the time between the same active ID if they are active multiple times during that same week.

The same type of question is applicable for other analysis I need to do -- do X if Y and Z are the same. The only thing is that it needs to be able to look through the excel sheet to see if there are multiple Y and Z's.

does that make sense?

Thanks for your help!!

 

[Akashwani]

Hi and welcome to MrExcel.

If you can provide some sample date of the table/range you have and the expected results you expect, then this will help people provide you with the appropriate solutions.

Something like this...

Excel Workbook
	A	B	C	D	E	F	G
1	ID	Day of Week	Week of	Start Date/Time	End Date/Time	*	Result Hrs
2	10	Mon	11	10/12/2012 21:00:31	12/12/2012 22:00:23	*	*
3	11	Sun	11	09/12/2012 21:00:31	12/12/2012 22:00:23	*	72:59:52
4	10	Sat	10	08/12/2012 20:00:31	12/12/2012 22:00:23	*	97:59:52
5	12	Fri	11	07/12/2012 19:00:31	12/12/2012 22:00:23	*	*
6	11	Thu	11	06/12/2012 20:00:31	12/12/2012 22:00:23	*	145:59:52
Sheet8

The formulas above need to be copied down.

I hope this helps.

Good luck.

Ak