Not 100% sure where to start on this one...
Basically I will have a table containing shift start / end time and number of people working e.g.
Shift Start | Shift End | Supervisors | Staff
1000 | 2000 | 1 | 5
1200 | 2200 | 1 | 3
etc...
(will be other bits such as date but left out as not important atm)
What I would then like to do is a simple line / bar graph showing number of workers over a 24 hour period with 0-23 across bottom and then count running across.
So with above example for supervisors it will be 0 for 0-9, 1 for 10 & 11, 2 for 12-19, etc...
Can anyone think of a simple way of doing this? (also there will be night shifts to make things a bit more akward).
EDIT:
Forgot to say graphing etc... I can manage, just after a way of returning the raw numbers.
Also only see math forum after I posted *doh* sorry for a wrong forum 1st post