slamanager
Board Regular
- Joined
- Apr 20, 2007
- Messages
- 129
Hi All,
I know this is a question like using Sumproduct to total data between dates but i just cant get this to work.
Each line in the report shows a status change with in a record there are multiple records in the report, also there are random combinations of status changes per record. Im trying to sum the minutes in duration between two of the status types.
example data in cols A B C. A is the record ID B is the Status value and C is the duration for each status.
INC0001, Start, 15
INC0001, Process1, 5
INC0001, Process2, 11
INC0001, Process4, 6
INC0001, Process1, 5
INC0001, End, 7
INC0001, Refresh, 5
INC0002, Start, 15
INC0002, Process1, 5
INC0002, Process2, 14
INC0002, Process1, 5
INC0002, End, 7
So I need to calc the duration for INC0001 between Start and End points giving a total of 49 and INC0002 total of 46. the sumproduct example i have is for date ranges which ive tried to modify by unsure how to combine the INC ref and the status and then add up between those points.
Cheers
I know this is a question like using Sumproduct to total data between dates but i just cant get this to work.
Each line in the report shows a status change with in a record there are multiple records in the report, also there are random combinations of status changes per record. Im trying to sum the minutes in duration between two of the status types.
example data in cols A B C. A is the record ID B is the Status value and C is the duration for each status.
INC0001, Start, 15
INC0001, Process1, 5
INC0001, Process2, 11
INC0001, Process4, 6
INC0001, Process1, 5
INC0001, End, 7
INC0001, Refresh, 5
INC0002, Start, 15
INC0002, Process1, 5
INC0002, Process2, 14
INC0002, Process1, 5
INC0002, End, 7
So I need to calc the duration for INC0001 between Start and End points giving a total of 49 and INC0002 total of 46. the sumproduct example i have is for date ranges which ive tried to modify by unsure how to combine the INC ref and the status and then add up between those points.
Cheers