Formula involving timings

[Laura_Nic]

Hi,
I wonder if anyone can help.

I have a spreadhseet that is downloaded from a staff rota system.
Let's say I have the staff name in column A, the shift start time in column B and the shift end time in column C (times in hh:mm format).
I need to work out who is present at work between the hours of 08:00 and 09:00.
Is there a quick way to do this??
I can obviously juggle about with autofilters between times but wondered if anyone knew of a formula method?

Thanks,
Laura

 

[CsJHUN]

Useing filter or autofilter on B and C is good idea, but what you need to do with them?
Autofilter: B>08:00 and C<9:00