Thanks Max and Pete, that's done the trick

"Pete_UK" wrote:

Try this:

=SUMPRODUCT((A1:A10="ENT")*(B1:B10=--"8:00:00")*(B1:B10<=--"16:00:00"))

Or, you could put ENT in C1, the start time in D1 and the end time in
E1 and use:

SUMPRODUCT((A1:A10=C1)*(B1:B10=D1)*(B1:B10<=E1))

Hope this helps.

Pete

On Feb 24, 1:17 am, Noetic76
wrote:
hi, I have a table that looks something like this:

Unit Time
ENT 10:36:00
ENT 01:15:00
EMU 12:36:00

etc etc.

I need to be able to calculate number of entries per unit per time range, eg
the numbers of times ENT occurs between 8am and 4pm.

Any suggestions?
Thanks, Ruth

.