Hi all,
I have a list of times of which i need to know how many are after 7pm and before 7am. I have used the following statement but its returning 0 so i am assuming that im wrong:
=COUNTIF(RANGE,">07:00:00<19:00:00")
Its cleary wrong..but does anybody have any ideas on this one? Thanks,
Phil
Something like this:
=SUMPRODUCT(--(range>7);--(range<19))
(replace ; with , if needed)
Never use Merged Cells in Excel
Thanks for the fast reply mate, but it doesnt work :-( still returns zero!
sorry... /24
=SUMPRODUCT(--($G$8:$G$13<19/24);--($G$8:$G$13>7/24))
Last edited by zbor; 08-24-2009 at 10:05 AM.
Spot on mate, thanks very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks