| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to Date/Time Range
I have a column with a months worth of date/time entries that are in 15
minute increments and I want to create a formula that refers to a range that is NOT a weekend day and is greater than 9:00 and less than 21:15. This will identify a PEAK usage time-frame each day. Sample Data: 4/2/2007 8:00 4/2/2007 8:15 4/2/2007 8:30 4/2/2007 8:45 4/2/2007 9:00 4/2/2007 9:15 4/2/2007 9:30 4/2/2007 9:45 4/2/2007 10:00 I've tried usinge the WEEKDAY() function in combo with the HOUR() and MINUTE() functions but I just can't seem to come up with anything that works! Any suggestions will be greatly appreciated!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a cell refer to a Range of cells? | Excel Discussion (Misc queries) | |||
| How does one refer to the n-1 element of a named range? | Excel Discussion (Misc queries) | |||
| How do I refer a Range to a Cell | Excel Worksheet Functions | |||
| How do I refer to a non-empty row range in Excel | Excel Discussion (Misc queries) | |||
| syntax to refer to a range as an array? | Excel Worksheet Functions | |||
Threaded Mode
