| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif in a time range
I have a list of 14,000+(DTTM) dates and times from a month, (i.e.9/1/2008
9:20:00 AM). I need to count how many rows have a time stamp between 08:00 and 17:00. I copied the column over one and formated it down to a 24 hour time format. Is there a way to trim this column or write a formula that only counts thte time? Thanks Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF with age range | Excel Worksheet Functions | |||
| Using countif with a name of a range | Excel Worksheet Functions | |||
| countif using a range | Excel Worksheet Functions | |||
| countif and sum if over a range. | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Threaded Mode
