hi
i'm not sure i completely understand what your are trying to do with such
sketchy information but if this will help, see these sites. they have already
worked up some timesheets that might help.
http://j-walk.com/ss/excel/files/timesht.htm
http://www.cpearson.com/excel/overtime.htm
at the bottom of chip's site are a number of links to other timesheet
related stuff.

regards
FSt1

"Peter Balcombe" wrote:

(Newcomer please be gentle!)

I am trying to set up a monthly time sheet spreadsheet for an organisation
that has staff working 7x24.

Ideally I should like the spreadsheet to automatically assign the date and
day of the week working from user input data (from drop down lists for
month, and year) so that for the current month (May 2008) the information
would appear as follows:-

Day Date

Thursday 1
Friday 2

and so on to

Friday 30
Saturday 31


Obviously the spreadsheet would need in some way to work off Julian calender
data.

Is this possible or do I ask too much?


Peter