I'm sorry,

This is the time sheet template from Microsoft that I use:

http://tinyurl.com/yo6wbp

I've very easily augmented it for a month by extending-formatting the
time sheet from a week to a month and then I have 4 weekly time sheets
for the 4 weeks of the month after that in the same book, 6 pages
total.

So, my book starts with a cover page with the Business name and address
and mine too. Followed by the monthly work sheet (usually titled "Jan
2008" - "Month Year"). Followed by 4 weekly time sheets (titled "Week
1" etc.)

I also format my monthly sheets to start from the first day of each
month and include the entire month on each monthly sheet. I don't
follow a strict 4 week cycle.

For the weekly time sheets I just add the extra or minus days of the
month onto the last week of the 4 weeks. I then start on a new book.

The owner just wants to use it for a reference to see what I'm doing
and how he can advise me to cut corners.

But looking at the Microsoft template I think should show you
everything that you need for this. If not please let me know.

However, this template includes calculations for over time. I do not
need this, I don't get over time. In fact I don't remember a single
day of working more than 7 or 8 hours.

I have not so far tempered with the "Regular Hours" formula but I have
looked at it and see how I can take the over time out and simplify it.
If that will aid in getting what I'm after by all means please let me
know.

I have taken the "Over Time" column out and I changed the "Sick Time"
column to "Misc." - I get payed a fee for lock outs that I may include
here.

Everything else is just as is from the template.

Also, if possible I would like to automate everything, not only the
"Hours" and "Description" from the monthly to the weekly time sheets
but if I can also get it to carry over the formatting from when I first
put the day and date in on the monthly time sheet to have that
automatically carry over to the weekly time sheets that would save a
lot of time too.

Thanks,

John


Bill Manville;2571221 Wrote:
It is difficult to advise without knowing the layout of your monthly
timesheet. You haven't given us enough clues to be able to divine it.
Nor do we know how you want the weekly timesheet laid out.

For example, your timesheet might be like this:

Date Hours Comment
1-Jan 4.5 "This is what I did"
2-Jan 8.5 "Cleared snow"

etc. with a separate sheet for each month.

and you might want a similar format for the weekly presentation but
with just 7 days.

Here is a possible approach:

The weekly sheet contains the week start date in A2, e.g. 7-Jan-2008
A3 contains =A2+1 and this is copied down as far as A8 (which will then

contain =A7+1). By changing A2 you will get a different week showing
up.

Now in B2 of the weekly sheet we want to get the hours for 7-Jan (or
whatever the date is in A2). We could use
=OFFSET(JanSheet!B$1,DAY($A2),0)
where JanSheet is the name of January's monthly timesheet.
This will give us the value of the cell 7 rows down from B1 on JanSheet

(ie the hours for 7-Jan)

We could copy this formula to B2:C8 and we would have the week's time
data. Change A2 to 14-Jan-2008 and we get a different week's data.

An obvious problem will arise at the end of a month when the data for a

week has to come from 2 sheets. You could edit the formulas so that
for the February dates they reference FebSheet, but smarter would be to

get the formulas to adjust themselves using the INDIRECT function. You

could make B2 on the weekly sheet contain
=OFFSET(INDIRECT(TEXT($A2,"mmm")&"Sheet!A$1"),DAY( $A2),COLUMN()-1)









Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup




--
Johnz414