Need help with excel

Question

I have 2 sets of data wherein in need to find,\

if Indicator indicates alarm then it needs to calculate time difference between the time its start STOPPED to ALARM and ALARM TO MOVING as per Indicator Column. please there can be instance wherein alarm go multiple time but it should only subtract with closest stopped indicator as shown in second table. Need one line formula.

in sample sheet i have taken out ID Column accidentally but i do have different ID for each class we can group as per below.

Time	Class	ID	Status	Indicator
1:00:51 AM	Asset	A	Moving Status	Stopped
1:00:59 AM	Asset	A	In Service	Alarm
1:09:31 AM	Asset	A	Moving Status	Moving

2:22:27 PM	Assest	B	Moving Status	Stopped
2:23:07 PM	Assest	B	In Service	Alarm
2:29:47 PM	Assest	B	In Service	Alarm
2:34:14 PM	Assest	B	Moving Status	Moving

ramiz_assaf · Answer

Jeev125&nbsp;I am feeling you need to update your excel file,anyways, here is the formulas that find the last stopped if alarm and the last alarm if moving,If you need the id just add it using and AND()&nbsp;&nbsp;