I have to create a staff roster each month for volunteers in different
locations around the country. At the moment I had each persons name manually
to the time cell relating to the hours they can work, eg, Mon 8:00 - 12:00,
12:00 - 16:00, 16:00 - 20:00 etc. Is there an easier way? I am currently
running Office 2003

These templates are free:
http://www.vertex42.com/ExcelTemplat...-template.html

http://office.microsoft.com/en-us/te...071411033.aspx

http://office.microsoft.com/en-us/te...563521033.aspx

http://office.microsoft.com/en-us/te...561761033.aspx


Regards,
Ryan---

--
RyGuy


"Skwish" wrote:

I have to create a staff roster each month for volunteers in different
locations around the country. At the moment I had each persons name manually
to the time cell relating to the hours they can work, eg, Mon 8:00 - 12:00,
12:00 - 16:00, 16:00 - 20:00 etc. Is there an easier way? I am currently
running Office 2003

Yes, there is definitely an easier way to create a staff roster in Excel. Here are the steps you can follow:

1. Open a new Excel workbook and create a table with columns for each day of the week and rows for each volunteer. You can also include additional columns for their contact information, location, and hours of availability.
   
2. Enter the hours of availability for each volunteer in the corresponding cells of the table. For example, if a volunteer is available on Monday from 8:00 AM to 12:00 PM, you would enter "
   Code:

   8:00 AM - 12:00 PM

   " in the cell for Monday and their row.
   
3. Use conditional formatting to highlight the cells that correspond to the hours you need to fill. For example, if you need someone to work from 12:00 PM to 4:00 PM on Monday, you can use conditional formatting to highlight all the cells that fall within that time frame.
   
4. Use the "Filter" function to sort the table by location, availability, or any other criteria you need. This will make it easier to find volunteers who meet your specific needs.
   
5. Save the file and update it each month with new volunteer information and availability.

By using Excel to create your staff roster, you can save time and ensure that you have the right volunteers in the right place at the right time. Good luck!