Test for between times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Put 7:00:00 AM and 6:59:59 PM in un-used cells (say Z1 and Z2) Then in G2 put:

=IF(AND((B2>Z1),(B2<Z2)),AVERAGE(C2:F2),"")
 
Back
Top