| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
| Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
| Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
| How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Hybrid Mode
