Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Occurences Formulas
I am trying to find out if something occurred between certain hours of the
day. I am looking at 1 hour time bands between 5 pm and 6 am, which is between 17:00 and 6:00. I need a formula that will compare the start and end times (between 17:00 and 6:00, and return a True value if it occurs in each one hour time band. For example, I want a True returned if something occurred between 17:00 and 18:00, in which case that something's actual times are 17:15 and 17:45. So since these times are between that 17:00 and 18:00, I want a True entered. How can I write a formula for this? Also, is there any exception to the formula when going past 24:00? thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting events since last occurences | Excel Worksheet Functions | |||
Counting the occurences | Excel Worksheet Functions | |||
Counting Occurences of Hours of the Day | Excel Discussion (Misc queries) | |||
Counting Occurences | Excel Discussion (Misc queries) | |||
Counting Number of Occurences | Excel Discussion (Misc queries) |