View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Noetic76 Noetic76 is offline
external usenet poster
 
Posts: 4
Default need help with look-up and time rage

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