OK heres a good one for you guys to help me with

A B C D E F
1Name In Out Total Pay Total
Employee Time Time Time Rate Pay

2 Sean 5:00 am 1:00 pm 8 $7.00 $56.00

Now On Sheet2 I want to pull the number of hours that sean worked between my
shift which are 5 to 11am, 11am to 1:30pm, 1:30 to 5:00pm 5 to 8pm and 8 to
12am. So if it works it would tell me that i had one employee for shift 5 to
11 and one for 11 to 1:30. Simple Right at least i hope so.
Thanks in advance