G
Gunjani
Where do I start... What I have is two worksheets one consists of ALL 99
employee names and there respective 'Duty Nos' for each day for the
whole year.
The first worksheet is laid out as follows:
Name Day1 Day2 Day3 Day4 Day5 Day6 Day7
Tom 22 22 56 55 R R 33
Dick 44 R R 15 15 15 15
Harry R R 76 65 65 65 65
Joe 07 07 R R 88 88 88
The second worksheet is the data related to the to the duty nos e.g
start time, end time, lunchtime, total daily hours, paid time etc...
These are all column headings.
I like to do combine the two worksheets to do several things...
1.I like to establish what hours each employee does for a specific week
/month /year.
2.Create worksheet or just a printout of a specific employee's duty no
and it's respective data for a specific week.
Where do I start?
--
Many Thanks
Gunjani
"A person starts to live when he can live outside himself."
-- Albert Einstein
employee names and there respective 'Duty Nos' for each day for the
whole year.
The first worksheet is laid out as follows:
Name Day1 Day2 Day3 Day4 Day5 Day6 Day7
Tom 22 22 56 55 R R 33
Dick 44 R R 15 15 15 15
Harry R R 76 65 65 65 65
Joe 07 07 R R 88 88 88
The second worksheet is the data related to the to the duty nos e.g
start time, end time, lunchtime, total daily hours, paid time etc...
These are all column headings.
I like to do combine the two worksheets to do several things...
1.I like to establish what hours each employee does for a specific week
/month /year.
2.Create worksheet or just a printout of a specific employee's duty no
and it's respective data for a specific week.
Where do I start?
--
Many Thanks
Gunjani
"A person starts to live when he can live outside himself."
-- Albert Einstein