View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gregv7 gregv7 is offline
external usenet poster
 
Posts: 1
Default using a time format in a count function

I have a spreadsheet that has the following:
A B C
Start Time Run Day Run Time
11/14/09 12:20 AM Sat 12:20 AM
11/15/09 3:30 PM Sun 3:30PM

The cells are formatted as:
A= Date & Time
B=TEXT(A2,"ddd")
C=A2(cell reference with a time format)
My goal is to count how many times the event occurred on a particular day of
the week and count how many times it occurred during a time frame. EG Monday
between 5:00 AM & 8:00 AM
I have the count for the days of the week, I just can't get the occurrences
between the hours I need.
Thank you in advance!