Countif formula for time
I am trying to find a formula to count the number of times a time appears that is over 30 minutes. The times are all listed in Column 21 in the following format:
0:15, 0:27, 0:13, 0:20
I have tried using variations of the below formula but I get error messages.
Anyone have an idea of how to get the correct formula?
Thanks in advance!