the winning formula:

=SUMPRODUCT((ISNUMBER(SEARCH("AM",C5:C453)))*(K5:K 453=""))





I was trying ((--ISNUMBER(FIND("AM",C5:C453)))*(K5:K453=""))



Anyway, all is good until the size of this file and the volume of users
sharing the workkbook just kills the whole system.


I guess SEARCH works differently than FIND.







Bob Phillips Wrote:
Mod just takes the fractional part. As I read your post, C5:C160 was
date
and time and you just wanted the time, so I MOD it with 1 to get the
time,
and add these where K is blank.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"redneck joe"

wrote in message
...

Bob Phillips Wrote:
Is it not just

=SUMPRODUCT(--(K5:K160=""),MOD(C5:C160,1))

--
HTH

Bob Phillips




No it returned - #value.

I'm not sure what MOD is. That's new to me...


Any links to study up on that one?


--
redneck joe



------------------------------------------------------------------------
redneck joe's Profile:
http://www.excelforum.com/member.php...o&userid=32570
View this thread:
http://www.excelforum.com/showthread...hreadid=570547



--
redneck joe


------------------------------------------------------------------------
redneck joe's Profile: http://www.excelforum.com/member.php...o&userid=32570
View this thread: http://www.excelforum.com/showthread...hreadid=570547