holiday planner

i am trying to build a holiday planner, i am a beginner @ excel and i think i took on too much, but anyhow,

i am trying to get a few things happenning

1, have a main sheet to input holidays date from, date too which is easy enough but on sheet 2 i would like to take the info from sheet 1 and put it into a month with a max amount of persons of 10 having holidays at any one time else it would read space Free.

2 from a main sheet of rotas i have have got i would like to have total hours in week worked but this would be easy if it was day shifts but its nightshifts i.e 22:00 - 06:00 =(8) 7 hours with a hour taken off for dinner then with that information i would like to get holidays left to take in hours and days taken from the main holiday hours on main sheet all holidays input manully,

and a few other things

if anyone can help me with stting this up or some software/freeware already avaliable please contact me

Hi Ashtrayjb,

What you are asking is a considerable amount of work to be done presumably for free. Small wonder you haven't had any posts back on this. You would be off hiring someone to do the job. Posts for such large jobs are not appropriate in a forum like this. However, if you are interested in paying to have the job done, e-mail me.

Sincerely,
Leith Ross