Date Time Ping1 Ping2 Ping3 Ping4
8/29/2005 7:04:55 AM 0 0 5 10
8/29/2005 8:05:10 AM 0 0 5 10
8/29/2005 1:05:10 PM 0 0 5 10
8/30/2005 7:05:10 PM 0 0 5 10
8/30/2005 6:45:10 AM 0 0 5 10

I have a excel sheet that has the above information, I want to find a
formula that tests to see is it is between 7:00:00 AM and 6:59:59 PM, then
get the average of the 4 pings.