|
Test for between times
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. |
Test for between times
Put 7:00:00 AM and 6:59:59 PM in un-used cells (say Z1 and Z2) Then in G2 put:
=IF(AND((B2Z1),(B2<Z2)),AVERAGE(C2:F2),"") -- Gary''s Student "CW3ter" wrote: 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. |
| All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com