If Difference between Time 2 and Time 1 is greater than 4 minutes for one of the ID then I want to set value as 1 for Group of same ID in column E.

Please check images.

ScreenShot.JPG