Easy way of doing staffing timetables

[Graeme]

Hi everyone! I need help!

I currently do up timetables for a sporting venue and the
staffing times are generally related to when the public
gates open.

What I would like to do is have a cell where I enter the
gates opening time and it automatically calculates when
the staff start their shifts. For example, some staff
start 1 hour before gates open, others 30 minutes before
gates open. This is the same for all events so I want to
just enter the gates time and have it automatically
calculate it.

Can anyone help?

 

[Paul B]

Graeme, have a look here at chip's site you should find what you need there
http://www.cpearson.com/excel/datearith.htm

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **