Working between times

[Anonymous]

Hi

I have a group of staff with shifts.  I am trying to create a chart that displays how many staff I have on duty for different times of the day.

The relevant fields I have the staff red,Date, Shift start time, and Shift end time.

I need the chart to show how many staff are on duty at 7am, 8am, 9am, 10am ....... for any given date

How can this be achieved ???

Any help appreciated.  (please go easy on me as I am a bit of a novice)

Thanks

Phil

[#2]

Hi Phil,

     Sorry for the late reply. I was little bit busy with my work. Can you please attach your sample file. I want to check once again.

Thanks,

Ashutosh