Find time in a column based on character and minimum duration

[marjones]

Find character in a column based on time and minimum duration



Hello all!



I have two columns: column A contains time in hour, min, and sec (for example, 19:00:00) from 19:00:00 to 6:59:50 in 10 sec increments. For every time point in column A, there is a character in column B ‘W’, ‘S’, or ‘P’.

19:34:50​	W
19:35:00​	W
19:35:10​	W
19:35:20​	W
19:35:30​	W
19:35:40​	W
19:35:50​	S
19:36:00​	S
19:36:10​	S
19:36:20​	S
19:36:30​	S
19:36:40​	S

I need to determine at what time ‘S’ begins at AND lasts for a minimum duration of 60sec. So say the first instance of ‘S’ occurs at 19:29:20, but does not last for a total of 60sec.

19:29:20​	S
19:29:30​	S
19:29:40​	S
19:29:50​	S
19:30:00​	W
19:30:10​	W
19:30:20​	W
19:30:30​	W

Because this occurs first, but does not last 60s seconds, I want to skip this section and find where ‘S’ occurs AND lasts 60 seconds.



Any guidance would be greatly appreciated!