Nice idea lack of knowledge!
 

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?

Nice idea lack of knowledge!
 

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.

"carnelain" wrote:

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?

Nice idea lack of knowledge!
 

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.


"kassie" wrote:

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.

"carnelain" wrote:

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?

Nice idea lack of knowledge!
 

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

"carnelain" wrote:

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.


"kassie" wrote:

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.

"carnelain" wrote:

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?