Time between events

[simon354]

Hello
I'm looking for a good idea as I am not sure where to start on this project.
I have a list of events, every time an alarm is raised, and every time the state goes back to normal. Sometimes the program makes two alarm or two normal events, but I am only looking at the first alarm and the first "back to normal" each time. (marked with green just to show)
I need to find the total time, the program has been in "alarm" and sum that up for the month (or between to dates)
I guess I have to start by making the timestamp column (A) a time, and not just text, but what then? How do I find an Alarm and look for the next Normal upwards in the sheet? I hoped I could look for the next "New state" in column G, but those seem random.
Thanks in advance for your input

 

[simon354]

Installed Xl2bb

V231600io.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Timestamp	Object Name	Object Description	Message	Active Time	Condition Name	New State	Event Type	Process Section	Priority Level	Alarm State	Severity	Class
2	2022-10-24 19:08:28.480	V231600IO	MULTI SKRUBBER	Normal	2022-10-24 18:55:07.280	Value	5	Condition	5	2	RTN	750	1
3	2022-10-24 18:59:47.633	V231600IO	MULTI SKRUBBER	Alarm	2022-10-24 18:55:07.280	Value	7	Condition	5	2	ACT	750	1
4	2022-10-24 18:55:07.280	V231600IO	MULTI SKRUBBER	Alarm	2022-10-24 18:55:07.280	Value	3	Condition	5	2	ACT	750	1
5	2022-10-24 11:07:10.843	V231600IO	MULTI SKRUBBER	Normal	2022-10-24 11:06:37.270	Value	5	Condition	5	2	RTN	750	1
6	2022-10-24 11:07:00.673	V231600IO	MULTI SKRUBBER	Alarm	2022-10-24 11:06:37.270	Value	7	Condition	5	2	ACT	750	1
7	2022-10-24 11:06:37.270	V231600IO	MULTI SKRUBBER	Alarm	2022-10-24 11:06:37.270	Value	3	Condition	5	2	ACT	750	1
8	2022-10-24 11:06:13.827	V231600IO	MULTI SKRUBBER	Normal	2022-10-24 11:05:33.810	Value	5	Condition	5	2	RTN	750	1
9	2022-10-24 11:06:03.130	V231600IO	MULTI SKRUBBER	Alarm	2022-10-24 11:05:33.810	Value	7	Condition	5	2	ACT	750	1
10	2022-10-24 11:05:33.810	V231600IO	MULTI SKRUBBER	Alarm	2022-10-24 11:05:33.810	Value	3	Condition	5	2	ACT	750	1
11	2022-10-24 11:05:29.360	V231600IO	MULTI SKRUBBER	Normal	2022-10-24 11:04:25.157	Value	5	Condition	5	2	RTN	750	1
12	2022-10-24 11:05:13.203	V231600IO	MULTI SKRUBBER	Normal	2022-10-24 11:04:25.157	Value	1	Condition	5	2	RTN	750	1
13	2022-10-24 11:04:25.157	V231600IO	MULTI SKRUBBER	Alarm	2022-10-24 11:04:25.157	Value	3	Condition	5	2	ACT	750	1
14	2022-10-23 06:20:45.767	V231600IO	MULTI SKRUBBER	Normal	2022-10-23 05:26:21.060	Value	5	Condition	5	2	RTN	750	1
15	2022-10-23 05:28:48.247	V231600IO	MULTI SKRUBBER	Normal	2022-10-23 05:26:21.060	Value	1	Condition	5	2	RTN	750	1
16	2022-10-23 05:26:21.060	V231600IO	MULTI SKRUBBER	Alarm	2022-10-23 05:26:21.060	Value	3	Condition	5	2	ACT	750	1
17	2022-10-21 22:06:28.377	V231600IO	MULTI SKRUBBER	Normal	2022-10-21 20:54:02.787	Value	5	Condition	5	2	RTN	750	1
18	2022-10-21 20:54:40.920	V231600IO	MULTI SKRUBBER	Alarm	2022-10-21 20:54:02.787	Value	7	Condition	5	2	ACT	750	1
19	2022-10-21 20:54:02.787	V231600IO	MULTI SKRUBBER	Alarm	2022-10-21 20:54:02.787	Value	3	Condition	5	2	ACT	750	1
Data

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Time between events
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[simon354]

My apologies. Solved on the link in #3