View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Molasses26 Molasses26 is offline
external usenet poster
 
Posts: 8
Default 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!!