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
|