Hi,

I am trying to resource staff. How can I take two inputs in a table
(their start time and finish time) and add the person to another table
which contains the amount of staff available at a given time. For
example, if someone starts at 12:00 and finishes at 20:00, the second
table would show 1 person available for each hour between those
times. The second table is just a count of staff available during the
hour.

I hope I have explained my problem.

Any help would be greatly appreciated.
Kind regards,
Matt

Have a look at this site:http://www.contextures.com/excelfiles.html
there is a sample workbook (DV0001) you can download for free which may give
you some ideas.
--
jb


"MJKelly" wrote:

Hi,

I am trying to resource staff. How can I take two inputs in a table
(their start time and finish time) and add the person to another table
which contains the amount of staff available at a given time. For
example, if someone starts at 12:00 and finishes at 20:00, the second
table would show 1 person available for each hour between those
times. The second table is just a count of staff available during the
hour.

I hope I have explained my problem.

Any help would be greatly appreciated.
Kind regards,
Matt