How can I make a schedule for 4 part-time and 3 full-time staff?

H

hhspotts

I have 2 teams out on vehicles during the day. One team works 8-5 and the
other team's hours vary anywhere from 8:30-5:30, 9-6, 10:30-7:30, etc.

I'd like to find a way to do a schedule that all I have to do is plug in
names--any recommendations on how to do this?
 
D

deebs

I'd be tempted to Excel.

In the date column use a following workflow assuming the source date is
placed in cell A1

In the example I'll use 05/08/2006

05/08/2006
=a1+1

then copy the formula down the sheet

An advantage of incorporating source & formulas into dates is:

change the source date and all other dependent dates will update
automagically.

The above will give incremental dates one day at a time

A similar approach using
=a1+7

will update dates one week at a time
 
Top