time ranges

Giganews Newsgroups
Subject: time ranges
Posted by:  diana (anonymo…@discussions.microsoft.com)
Date: Mon, 20 Oct 2003

hi,  I'm currently using ==COUNTIF(F:F,"1:00 PM") to find
all the instances of 1:00 PM in my f column of my
spreadsheet.  What i'm wondering is if there is anyway I
can count all the instances of ranges like all the times
that fall in between 1 pm - 5 pm.  Anyone know how?

Thanks

Replies