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. |
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) |