how to group a same value into array excel

I have a duplicate value in column A with different value in column B and C. For example

There are 3 column which is A,B and C. A have duplicate value which is serial number and B is whether it fail the test or not and C is the time for testing. Is it possible by using excel to find different between time for first fail and pass. I want to delete the data that have less than 12 hour so that I know the things doesn't need rework just retest. I want to know the exact how many module that need rework.