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