Nice idea lack of knowledge!

C

carnelain

Hi,

I want to make a .xls with my working hours to calculate my wage. I designed
myself a lay out but I can't make it. What I want is 13 identical tabs for my
periodes. Within one tab I want the dates of those periodes "grouped" in
weeks. With this I mean: I want rows 1 and 2 to be empty (for now). The next
7 rows of the first coloms have the 7 dates of the first week. Then again 2
blank rows and the next week begins. Till I have 4 weeks which make up one
periode. Above one tabel which makes up a week I want a one cell telling me
the week number (hence the reserved free rows).
This is the general lay-out. But I want it to be automated. In colom A row 1
I want to type the year (2006 is this case) and I want to write down the date
of the first of the first day of the first week of the year. With this info I
want the file to calculate all dates; weeknumbers etc.

I know I want a lot. And I admit I do not have the full grasp of the scope
of this problem but I think it's possible but I don't know how to build it.
Is there anybody who can assist me with general guide lines and maybe an
other angle of looking at this problem?
 
K

kassie

Would this mean that you are going to use one row just for a date, and maybe
a start time, end time, total time and amount? In stead of using rows, why
don't you use column instead. Iow, have one period's dates in a single row?
And then obviously have 13 rows? Just wondering, as I do not have enough
detail to really make a suggestion.
 
C

carnelain

Yes, I want to use one row for one date. In the row is also coming the start
and end time of my shift. I have formulas to calculate my breaks and my extra
hours. And I need a sum of the weeks total. I am getting paid every 4 weeks
which is the period so I want a sum of my wage of every period and I want to
have every period on a different tab.
I hope this is enough info. Just ask for more if you need.
 
K

kassie

I'll see what I can work out. Still don't think it is the best way, but
that's what you want!
 
Top