excel formula for if time exceeds 30 minutes then yes

[jquinlavin]

Hi, I have spent hours trying to figure this out. I have a "time time to clear" which has been calculated by subtracting "arrived" from "cleared". I now need to identify those "time to clear over 30 minutes. I have played with the IF function and I thought I had it but when copy and paste the formula, all cells displayed yes, even if yes is not correct. I deleted the erroneous "yes" from this image

ems unit

date

dispatched

enroute

arrived

cleared

time to clear

delayed

:30

851​

1/1/2023

8:46

8:46

8:59

10:51

1:52​

yes

AET1

1/1/2023

9:52

9:52

9:57

10:20

0:23​

0:00

AET2

1/1/2023

10:18

10:18

10:32

10:46

0:14​

test

851​

1/1/2023

14:54

14:54

14:59

16:02

1:03​

AET1

1/1/2023

14:54

14:57

14:57

15:30

0:33​

 

[Scott Huish]

=IF(G2>"0:30","yes","")

Copy down.

 

[jquinlavin]

thanks very much